[CONJ-140] mariadb-java-client-1.1.8 shows no tables in OpenOffice Base Created: 2015-02-24  Updated: 2016-05-23  Resolved: 2016-05-23

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: all
Fix Version/s: 1.4.5

Type: Bug Priority: Minor
Reporter: Joerg Junge Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None
Environment:

Windows 7 64-bit, OpenOffice 4.1.1, mariadb-java-client-1.1.8

Issue Links:
Problem/Incident
is caused by CONJ-218 MariaDbDatabaseMetaData wrong TABLE_T... Closed

 Description   

Connecting with the jdbc driver to a database will not show any table, only views.
Querying of Tables with sql statements is possible, but only if you know the tables name.
Using the OpenOffice Query Designer is not possible, because it can not see any table.

If I use the mysql odbc or the mysql jdbc (mysql-connector-java-5.1.34) the tables will show.
I didn't test with mariadb odbc.

Cheers JJ

 Comments   
Comment by Diego Dupin [ 2016-05-23 ]

This problem is corrected with CONJ-218 (correction in 1.4.5).
Driver was using mariadb/mysql tables type, so "BASE TABLE" for table.
JDBC is only making recommendation about DatabaseMetaData.getTableTypes() to use "TABLE".

Since a lot of tools are implementing type "TABLE", Driver has improved to use JDBC recommendation.

Generated at Thu Feb 08 03:13:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.