Knowledge base

Purchasing 16

• 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 16 articles

License Renewal 6

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

See all 6 articles

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 6

• Debugging the installer
• Debugging the launcher
• How do I launch DbVisualizer manually?
• "No suitable driver" error message
• Use alternative folder for DbVisualizer user settings

See all 6 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

• DbVisualizer 13 errors
• Why are there no arcs between the tables in the references graph?
• 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 change the memory for Java?

Security 6

• SSH tunnel, SSL/TLS and truststore
• SSH "config" file parsing
• SSL (Secure Socket Layer)
• SSO (Single Sign-On)
• TLS: "The server selected protocol version TLS11 is not accepted by client preferences"

See all 6 articles

DbVisualizer on Windows 11

• Windows: Win32ShellFolderManager2.getPersonal] Cannot access 'Personal'
• Windows: Corrupt UI
• Windows: Cannot copy to system clipboard
• Windows: High CPU usage when idle
• Windows with Java 9+: Insertion point in editor doesn't align with cursor

See all 11 articles

DbVisualizer on macOS 10

• macOS: Spinning beach ball when expanding Database tab tree
• 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

See all 10 articles

DbVisualizer on Linux 10

• 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 10 articles

Generic database/driver solutions 1

• Set query fetch size

Adobe Experience Platform 1

• Adobe Experience Platform Query Service: fetch limit

Azure SQL Database 1

• Azure SQL Database: Connect to Azure using active directory (AD) authentication

Db2 LUW, Db2 z/OS, Db2 iSeries (AS/400) 8

• 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 don'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 8 articles

Google BigQuery 1

• Google BigQuery: Authentication

HIVE 2

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

Informix 3

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

JavaDB/Derby 1

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

MariaDB 1

• MariaDB: UTF-8 Character Sets and Collations

MongoDB 0

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

ODBC access 1

• ODBC: Connecting to ODBC data sources

Oracle 14

• Oracle: UnsatisfiedLinkError when connecting using the Oracle OCI driver
• Oracle: Single Sign-On (SSO) using Kerberos
• Oracle: Bad performance running queries
• Oracle: Connecting to Oracle Analytics Cloud Autonomous Data Warehouse using Oracle Wallet
• Oracle: Stored procedure/function columns are listed several times

See all 14 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 an 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 3

• Snowflake: Using OneLogin as SSO
• Snowflake: "Fail to retrieve row count for first arrow chunk..."
• Snowflake: Login using private key

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 6

• 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

See all 6 articles

Vertica 1

• Vertica: Executing SQL takes very long time