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 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

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