[TORQUE-40] jdbc task fails on sybase database (schema is set)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 3.2
• Fix Version/s: 3.2
• Component/s: Generator
• Environment: Sybase ASE 12.5; jConnect for JDBC 2.0 v5.5 Build 25137 or v6.05 Build 25828; Java Tds Server Classes v5.5 Build 25138 or v6.0 Build 25828
• Assignee: Thomas Fox
• Reporter: Thoralf Rickert
• Created: 12/Jul/06 15:49
• Updated: 26/Nov/06 18:23
• Resolved: 15/Jul/06 07:37

Description

The Sybase JDBC driver doesn't expect a parameter for databaseSchema in

DatabaseMetaData.getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)
DatabaseMetaData.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
DatabaseMetaData.getPrimaryKeys(String catalog, String schema, String table)
DatabaseMetaData.getImportedKeys(String catalog, String schema, String table)

If it is set to something else than null the methods return nothing. So please add the following fix (pseudo code):

public void execute() throws BuildException
{
....
if (config("torque.database.type").equals("sybase"))

{ dbSchema = null; }

...
}