Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-176
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-176
Summary: DbLoader: questionable use of DatabaseMetaData.getTables()
Type: Bug
Status: Assigned
Priority: Trivial
Project: Cayenne
Components:
Cayenne Core Library
Fix Fors:
1.1 [BETA]
Versions:
1.1 [BETA]
Assignee: Andrus Adamchik
Reporter: Andrus Adamchik
Created: Wed, 28 Jul 2004 4:31 PM
Updated: Wed, 28 Jul 2004 4:31 PM
Environment: HSQLDB 1.7.2, Mac OS X
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.
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Wed Jul 28 2004 - 16:32:48 EDT