[CAY-176] DbLoader: questionable use of DatabaseMetaData.getTables()

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 1.1 [LEGACY]
• Fix Version/s: 1.1 [LEGACY]
• Component/s: Core Library
• Environment: HSQLDB 1.7.2, Mac OS X
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 28/Jul/04 23:31
• Updated: 17/Sep/04 03:33
• Resolved: 28/Jul/04 23:31

Description

From DatabaseMetaData.getTables() JavaDocs:

"...schemaPattern - a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search

tableNamePattern - a table name pattern; must match the table name as it is stored in the database..."

Still DbLoader.getTables() method converted null table name and schema to "%" pattern... Technically this should work as if the pattern was "null" (and it works indeed on most DB's), still there is one where it does not - HSQLDB, and only version 1.7.2 (1.7.1 on Linux is OK, go figure).

The solution - stop doing this conversion, and use null as it is - JDBC claims to support that.