Using JDBC or ODBC connectors (no difference) on mySQL the 'use schema name in syntax' preference isn't working. The schema names (TABLE_SCHEM) are blank in the TABLE view, although schema catelog (TABLE_CAT) is showing correct schema names. Not sure if this is a bug?
Great tool otherwise!
Last edit: Geoff Badham 2013-11-25
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Using JDBC or ODBC connectors (no difference) on mySQL the 'use schema name in syntax' preference isn't working. The schema names (TABLE_SCHEM) are blank in the TABLE view, although schema catelog (TABLE_CAT) is showing correct schema names. Not sure if this is a bug?
Great tool otherwise!
Last edit: Geoff Badham 2013-11-25
Hi,
Schema has been introduced in MySQL with version 5, and I only use an old 3.23 version. Will have to ask to experienced users of MySQL 5.
and thanks for the feedback :-)
Regards
PAscal
Hi,
I can reproduce with MariaDB 5.5
and if no databse is specified in jdbc url, schamas are not displayed in metadata explorer (see ticket #186)
PAscal
I confirm:
- MySQL support schema since release 5,
- JDBC driver 5.1.29 has not been updated, is still based on Catalogs
That's why TABLE_SCHEM is blank and why no schema is displayed in Metadata explorer
Regards
PAscal
Last edit: PAscal 2014-02-25
ticket #192 opened
https://sourceforge.net/p/sqleo/tickets/192/
Fixed in #192
Feedback are welcome (especially with MySQL 5)