DbVis Software
Home
Solutions
Users Guide
Release Notes
Download
Welcome
Login
Sign up
How can we help you today?
Enter your search term here...
Search
Login
or
Signup
to submit a new ticket
Check ticket status
Knowledge base
Licensing
Purchasing
15
DbVisualizer is licensed per user
End User License Agreement (EULA)
I have just ordered. When do I get the license key(s)?
Is there a shipping cost?
Is tax/VAT included in the pricing?
See all 15 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
DbVisualizer
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 uses?
How do I change the memory for Java?
Security
7
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 7 articles
Known Java issues for Windows, Linux, macOS users
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
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
Database Specific
Generic database/driver solutions
1
Set query fetch size
Adobe Experience Platform
1
Adobe Experience Platform Query Service: fetch limit
Azure SQL Database
2
Azure SQL Database: Connect to Azure using active directory (AD) authentication
Azure SQL Database: PKIX path building failed
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
4
Informix: BLOB and CLOB values are not displayed properly
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
7
MySQL: Error connecting
MySQL: Value '0000-00-00' can not be represented as java.sql.Timestamp
MySQL: TINYINT(1) values are displayed as true/false instead of number
MySQL: Connecting securely to a MySQL server
MySQL: Column aliases are not displayed as column headers in result sets
See all 7 articles
ODBC access
1
ODBC: Connecting to ODBC data sources
Oracle
15
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 15 articles
PostgreSQL
5
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
Using a password file (.pgPass)
PostgreSQL: Single Sign On (SSO) using Kerberos on Windows
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
5
Snowflake: Using OneLogin as SSO
Snowflake: "Fail to retrieve row count for first arrow chunk..."
Snowflake: Login using private key
Snowflake: Connect using SSO and the CData driver
Snowflake: NoClassDefFoundError when expanding Schemas
SQLite
1
SQLite: Using the "Attach Database" command
SQL Server
6
SQL Server: PKIX path building failed
SQL Server: Using SQL Server SSO or Windows Authentication
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
See all 6 articles
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
SingleStore
1
SingleStore Helios: Single Sign On (SSO) using JDBC Driver