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
31
votes
5 answers

dbvisualizer: set max rows in a select query

I am using DBVisualizer 8.0.6 and when I run a simply query like.... select * from table It only shows the first 1000 rows and then stops the query and displays in the bottom left corner... "Number of rows limited by maxrows" How do I change this…
HelloWorld
  • 4,251
  • 8
  • 36
  • 60
16
votes
3 answers

How to access *.mv.db file of H2 database?

I have created database with my own program and it appeared as mydatabase.mv.db file. But when I tried to access the same database with DbVisualizer, with apparently same parameters, it created two files mydatabase.lock.db and celebrity.h2.db and…
Suzan Cioc
  • 29,281
  • 63
  • 213
  • 385
10
votes
3 answers

How to show all tables/views in ER diagram with DbVisualizer

Is there a setting in DbVisualizer to display all tables in the "References" tab? I am using the free version (10.0) and when I click on a table with the References tab open I only see the direct relationships from this table. I'd like to see all…
tw1742
  • 1,424
  • 4
  • 18
  • 37
9
votes
1 answer

pgadmin 4 (or db visualiser) entity relation diagram

How do you make an entity relation diagram using pgAdmin v4 or DB Visualizer or any other open source tool? PG Admin There are lots of explainers for pgadmin III but they suggest that there should be a tab called 'graphical query builder under the…
Mel
  • 2,481
  • 26
  • 113
  • 273
9
votes
3 answers

Connecting to H2 server from DbVisualizer

I have configured my H2 database as follows: @Configuration @Profile({ Profiles.DEV }) public class DevDataSourceConfiguration { @Bean(initMethod = "start", destroyMethod = "stop") public Server h2WebServer() throws SQLException { …
balteo
  • 23,602
  • 63
  • 219
  • 412
6
votes
2 answers

How to import a SQLite db file into DbVisualizer

How can a SQLite *.db file be imported into DbVisualizer? Since the SQLite database file extension is *.db how can we load this into DbVisualizer to view the tables and generate the ER diagram?
Bibin Jose
  • 563
  • 4
  • 11
  • 19
6
votes
3 answers

Join conditions on multiple columns versus single join on concatenated columns?

I observe there are two ways to achieve an objective on multiple tables. A column in the resultset will be updated and speed may be a requirement. The resultset is obtained either by: Case 1: select ert.* from eval_rep_track ert inner join ( …
paxmemento
  • 281
  • 4
  • 10
6
votes
1 answer

SQL query on H2 database table throws ArrayIndexOutOfBoundsException

I have a H2 database on which some queries work, while others are throwing an ArrayIndexOutOfBoundsException. For example: SELECT COLUMN_1 FROM MY_TABLE; // works fine SELECT COUNT(COLUMN_1) FROM MY_TABLE; // gives following error message: [Error…
Kaadzia
  • 1,393
  • 1
  • 14
  • 34
6
votes
4 answers

The MySQL "DELIMITER" keyword isn't working

Ok so, I've been ripping my hairs ou on this one, why doesn't this work? DELIMITER | CREATE PROCEDURE Decrypt_pw() READS SQL DATA BEGIN SELECT 'Hey Select'; END| It's so basic and I'm pretty sure I'm using the correct syntax, what am I…
Pedro 'Xympa' Nascimento
  • 105
  • 1
  • 2
  • 8
5
votes
0 answers

How to get relationships to show on dbvisualizer?

I have tables inside a schema inside a DB. I need dbvis to graph/show the actual lines that show the relationships among the PKs as in the link below. https://www.dbvis.com/features/tour/references-graphs/ For some reason, I can only get dbvis to…
SwolleyBible
  • 243
  • 7
  • 20
5
votes
2 answers

Cannot browse a H2 database file?

I am creating a H2 database in my unit tests. The database uses the following properties: …
John Q Citizen
  • 321
  • 1
  • 6
  • 15
3
votes
0 answers

Create database ER diagram for existing DB - javascript

I want to create an ER diagram for a database schema using D3js (Or any other js lib if you have some suggestions). I want to create it because I didn't find the service that fits my needs. I want the diagram to update every time someone changes the…
idan ahal
  • 707
  • 8
  • 21
3
votes
1 answer

Postgres Escape Single and Double Quotes in Text Field

I may have an odd request. I'm not finding any help via Google. I am using the DbVisualizer Pro 10.0.15 gui tool connected to a PostgreSQL db. I need to create a csv file from a database table. I select the records I need in a query then export…
John Cowan
  • 1,452
  • 5
  • 25
  • 39
3
votes
1 answer

DB2 in Oracle SQL Developer - Schema driver error

I am attempting to access a DB2 database via Oracle SQL Developer. While I can connect to the database and run SQL code against it, I am having a issue accessing the schema. I receive the following 3 errors when connecting An error was encountered…
Scott Calkins
  • 31
  • 1
3
votes
1 answer

How to remove schema name from dbvisualizer export from command line

When I export a result set using @export, It gives me 'INSERT INTO abc.employee .......' I need to remove the schema name from here..... How can I get statement like 'INSERT INTO employee ......'? I am using following method export.sql : @export…
Anupam
  • 41
  • 4
1
2 3
…
14 15