Knowledge base

Purchasing 13

• DbVisualizer is licensed per user
• End User License Agreement (EULA)
• Can I get DbVisualizer on a media?
• I have just ordered. When do I get the license key(s)?
• Is there a shipping cost?

See all 13 articles

License Renewal 5

• What happens if I renew before the license has expired?
• My license has expired. Am I eligible to renew it?
• I am asked to specify Reference No when ordering the renewal. Were can I find it?
• Is license renewal required?
• Who needs to order a license renewal?

Tips & Tricks 11

• Merge result sets
• Copy/Paste of cells in grid
• Search full script in SQL History
• Maximize tabs
• Working with Tabs Side-by-Side

See all 11 articles

General 5

• Is DbVisualizer Open Source?
• Can I distribute DbVisualizer on an external media such as a CD?
• The references graph component is impressive. Is it for sale separately?
• Can I put a link on my web to the DbVisualizer pages?
• Where are my connections, bookmarks and other settings stored? How do I migrate these to another machine?

Installing & Getting Started 7

• Debugging the installer
• Debugging the launcher
• How do I launch DbVisualizer manually?
• I get "Invalid license key format" error at startup
• "No suitable driver" error message

See all 7 articles

JDBC Drivers 3

• What is JDBC?
• Which JDBC driver should I use?
• How do I load a JDBC driver and get connected?

Using DbVisualizer 11

• Why are there no arcs between the tables in the references graph?
• Cannot see synonyms, triggers, functions, stored procedures, views, aliases, data files, users, locks, etc
• Enable debug mode of DbVisualizer
• Can I disable data editing completely?
• Can I access tables across multiple databases within one statement?

See all 11 articles

Java related 5

• Java 9 beta support from DbVisualizer 10.0.3
• From which version is Java 8 supported?
• From which version is Java 7 supported?
• How do I change the Java version that DbVisualizer use?
• How do I increase the memory for Java?

Security 4

• SSH tunnel, SSL/TLS and truststore
• SSH "config" file parsing
• SSL (Secure Socket Layer)
• SSO (Single Sign-On)

DbVisualizer on Windows 10

• Windows: High CPU usage when idle
• Windows with Java 9: Insertion point in editor doesn't align with cursor
• Windows: java.awt.IllegalComponentStateException: component must be showing on the screen to determine its location
• Windows: Java/DbVisualizer crash at start after installing "Windows 10 Creator Update"
• Windows: Cannot copy to system clipboard

See all 10 articles

DbVisualizer on macOS 9

• macOS: DbVisualizer hangs with Big Sur
• macOS: DbVisualizer doesn't respond to mouse clicks or keyboard input
• macOS 10.14 (Mojave): Getting "dbvis_macos_9_5_8.dmg is damaged during installation" error
• macOS: Getting an error when multiple monitors
• macOS: Blurry text on Retina with Yosemite

See all 9 articles

DbVisualizer on Linux 11

• Linux: "Failed to retrieve atom name"
• Linux: Cannot select a data type in the Data Type drop-down in Create/Alter Table
• Linux: java.lang.StackOverflowError in componentResized
• Linux: ClassCastException referring "sun.awt.image.BufImgSurfaceData"
• Linux: Fonts looks terrible

See all 11 articles

Generic database/driver solutions 1

• Set query fetch size

Azure SQL Database 1

• Azure SQL Database: Connect to Azure using Active Directory (AD) authentication

DB2 LUW, DB2 z/OS, DB2 iSeries (AS/400) 7

• DB2 iSeries: Remarks not displayed
• DB2 iSeries: Tables are not listed if schema name contains underscore
• DB2 LUW, DB2 z/OS: Messages from the database/JDBC driver doesn't show any meaningful text
• DB2 LUW, DB2 z/OS: DbVisualizer may hang when executing erroneous SQL
• DB2 LUW: SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSIBM.SQLTABLES

See all 7 articles

HIVE 2

• Hive: Connect to Apache Hive/Hadoop
• Hive: Use DbVisualizer with Kerberized Hive

Informix 2

• Informix: Enable support for delimited identifiers
• Informix: Driver throws ClassNotFoundException: org.bson.BSONObject

JavaDB/Derby 1

• JavaDB/Derby: Errors and exceptions if using an incompatible JDBC driver

MariaDB 1

• MariaDB: UTF-8 Character Sets and Collations

MySQL 5

• MySQL: Error connecting
• MySQL: Value '0000-00-00' can not be represented as java.sql.Timestamp
• MySQL: TINYINT's are displayed as a boolean, TRUE/FALSE rather than 1/0
• MySQL: Connecting securely to a MySQL server
• MySQL: Column aliases are not displayed as column headers in result sets

Oracle 13

• Oracle: Bad performance running queries
• Oracle: Stored procedure/function columns are listed several times
• Oracle: Stored procedures/functions are displayed several times
• Oracle: Some stored procedure/functions are displayed as "xx.yy" in the database objects tab
• Oracle: DDL tab doesn't show for Oracle even if using Oracle 9 or later

See all 13 articles

PostgreSQL 3

• PostgreSQL: Out of Memory with large result sets
• PostgreSQL: The hostname xxx could not be verified by hostnameverifier PgjdbcHostnameVerifier
• PostgreSQL: Connecting to a SSL enabled PostgreSQL server

Redshift 4

• Redshift: Cannot connect with DbVisualizer 10.0.22 and later
• Redshift: High memory usage and DbVisualizer freezes
• Redshift: Connect with IAM
• Redshift: Access with Okta as an identity provider

REST API 1

• Using the DataDirect REST Connector

Snowflake 1

• Snowflake: Using OneLogin as SSO

SQLite 1

• SQLite: Using the "Attach Database" command

SQL Server 5

• SQL Server: Error during connect "java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter"
• SQL Server: Running MERGE statement fail
• SQL Server: Microsoft JDBC driver version 7.4.1 is broken when table names contains underscore
• SQL Server: Using SQL Server SSO or Windows Authentication
• SQL Server: Error reading prelogin response (TCP/IP)

Sybase ASE 5

• Sybase ASE: "showplan" doesn't show with the jTDS JDBC driver
• Sybase ASE: I get an UnsupportedEncodingException: xxx when connecting
• Sybase ASE: How to enable password encryption
• Sybase ASE: Table data edits are saved in wrong table
• Sybase ASE: Connecting with SSL

Vertica 1

• Vertica: Executing SQL takes very long time