Stack Overflow
Stack Overflow

Questions tagged [dbvisualizer]

DBVisualizer is a popular database tool by DbVis Software AB. Written in Java, it runs on Windows, Mac OS X, and Unix/Linux, and will connect to any JDBC enabled database server.

DBVisualizer is a popular database tool by DBVis Software AB. Written in Java, it runs on Windows, Mac OSX, and Unix/Linux, and will connect to any database server.

214 questions
2
votes
1 answer

Can DbVisualizer import table tata from a .sql file?

It seems that the only supported import data file format is .csv? http://www.dbvis.com/doc/9.0/doc/ug/exportImport/exportImport.html
Sam Su
  • 6,532
  • 8
  • 39
  • 80
2
votes
2 answers

Open h2 database file on Mac OSX

I'm having trouble opening a h2 database file on Mac OS X. I tried 'DbVisualizer' and 'RazorSQL', but h2 file doesn't open up properly. They show weird characters. I'm I doing something wrong or is there a better program to open up a h2 database…
wag0325
  • 1,008
  • 5
  • 18
  • 34
2
votes
1 answer

DbVisualizer.rpm is not converting to .deb?

I am using latest updated version of UBUNTU 12 operating system.I downloaded DbVisualizer.rpm from here.I tried to install DbVisualizer by converting .rpm into .deb format using the follwing command $ sudo alien DbVisualizer.rpm The above command…
kerZy Hart
  • 181
  • 4
  • 17
2
votes
1 answer

Returning results from a loop dbvisualizer

I'm pretty new to DbVisualizer (v6.5.5) and have been trying to get even a basic loop to return some results. Just something I can build off of but no luck and I can't seem to find anything online that helps. This query executes successfully (no…
N1tr0
  • 485
  • 2
  • 6
  • 24
2
votes
3 answers

something funny with embedded hsql

i'm just curious about something.I'm using hsql in myproject (embedded of course).At some time i felt the need to visualize what hibernate was generating.I took a free copy of dbvisualizer. here is the hsqljdbc.properties…
black sensei
  • 6,528
  • 22
  • 109
  • 188
1
vote
1 answer

Connect DbVisualizer to HSQLDB on Mac

I need to connect DbVisualizer to HSQLDB. I've installed both on my mac (OSX 10.6.9). I've installed DbVisualized 8.0.5, and HSQLDB. I have both open, but when I try to ping the server, I receive the error message: "Cannot connect to 'localhost' on…
Adam_G
  • 7,337
  • 20
  • 86
  • 148
1
vote
0 answers

GridDB: 10054:TXN_CLIENT_VERSION_NOT_ACCEPTABLE error while trying to connect to GridDB with DBVisualizer using the gridstore-jdbc JDBC driver

I have used DBVisualizer to add a Custom Driver via the Driver manager. I'm following the instructions located here I added the gridstore-jdbc.jar file to the custom driver. I select the Driver Class as com.toshiba.mwcloud.gs.sql.Driver The default…
user1366062
  • 163
  • 3
  • 16
1
vote
2 answers

How do I configure the Twig JDBC driver in DbVisualizer to connect to a Cassandra cluster?

I have an Ubuntu 20.04.5 install which has a Cassandra database which I want to connect to with DbVisualizer v14.0.1 using the Cassandra Twig driver (for reasons best known to my organisation). I have installed DbVis and downloaded the…
Matt W
  • 11,753
  • 25
  • 118
  • 215
1
vote
0 answers

Call Stored Procedure from DBeaver to DB2 not working

I'm trying to call STP from DBeaver or Jmeter with the following command example: @call SCHEMA.STPNAME( ${var_in1||AKTIVIER||String||dir=in noshow}$ , ${var_in2||AP||String||dir=in noshow}$ , ${var_in3||XXX||String||dir=in noshow}$ ,…
atarox
  • 11
  • 2
1
vote
1 answer

Importing Data in DB Visualizer

I am new to use DB Visualizer tool. I am using free version:12.0.8 I am able to export data from a source table as .CSV file. But am not able to import the data from the same .CSV file to target table. Can anyone please let me know how to proceed on…
nodev_101
  • 99
  • 10
1
vote
1 answer

How to execute multiple temp tables within a single query at one go in DBVisualizer?

I joined a new company and they are using DBVisualizer. For the last 5 years, I used SQL Server and I am now appreciating SQL Server for its intelligent execution of queries. One of the problems I am facing is executing multiple temp tables at a…
Pavan Koundinya Kaipa
  • 21
  • 2
1
vote
1 answer

Run Hive Script with variable - problem with passing variable

I'm using DBVisualiser to run the following script (Expecting to pass variable in query and retrieve data based on where condition) set Id='1'; select * from MyTable where account_id = '${hivevar:Id}' limit 5 Unfortunatelly, when I run this script…
Almir
  • 11
  • 2
1
vote
0 answers

Error while exxecutiong query on Aws Athena DB, error Code : 100123

I have setup AWS Athena DB and and can access it using AWS web console. select * from "Schema"."test_table" limit 10; Its giving me 10 records as expected. Then I have setup DBVisualizer database tool in EC2 instance in same VPC. Created a new Data…
ByteCode
  • 33
  • 5
1
vote
1 answer

DBVisualizer displays null on date field holding '0001-01-01'

I issued an SQL statement in DbVis: select vestdate, name from person where vestdate is not null And got many results where DbVisualizer showed vestdate as (null)! After investigating, I discovered that the vestdate was '0001-01-01', so the query…
Tim Morton
  • 2,614
  • 1
  • 15
  • 23
1
vote
1 answer

Connect to Derby Database using db visualiser

I'm trying to connect to a derby database using DB visualiser but I'm not sure where to start. In my Derby/bin folder I have a folder called COMPANYDB so I'm assuming this is the database itself. so in the connection details I'm trying to connect to…
Sparx
  • 109
  • 10
1 2
3
…
14 15