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 Entra (Active Directory) authentication
• Azure SQL Database: PKIX path building failed

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

• Db2 LUW: Enable SSL support
• 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

See all 9 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 1

• MongoDB: java.lang.IllegalArgumentException: No username is provided in the connection string

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