IBM Support

MariaDB Connector/J 3.0.3 and 3.0.4 returns incorrect metadata when connected to SingleStore

Troubleshooting


Problem

A connection to SingleStore is defined to use version 3.0.3 or 3.0.4 of the MariaDB Connector/J driver.
 
When the JDBC driver is asked to return metadata via the DatabaseMetadata interface, incorrect results are returned.

Version 3.0.3 does not return table metadata from the DatabaseMetadata.getTables method.

Version 3.0.4 does not return column metadata from the DatabaseMetadata.getColumns method.
 

Symptom

The <cognos>\drivers folder includes version 3.0.3 or 3.0.4 of the MariaDB Connector/J driver.

Cause



 

Resolving The Problem

Use an earlier version of the MariaDB Connector/J such as 2.7.3.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6nAAC","label":"Data Sources"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
29 April 2022

UID

ibm16575525