Bug #674: JDBC: DatabaseMetaData.getColumns() "feature"

Holger Mitterwald (hrmitter(at)lsd(dot)franken(dot)de) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
JDBC: DatabaseMetaData.getColumns() "feature"

Long Description
When trying to call the method DatabaseMetaData.getColumns with a a tablenamepattern (sTableName in the example) in uppercase, no columns are returned as postgreSQL 7.2.1 stores its tablenames in lowercase.

The TableNamePattern should be converted to lowercase for compatibilty reasons. Some Databases like Adabas and Oracle expect here uppercase strings, so the code has to be rewritten so that it runs with postgresql.

Problem occured on
PostgreSQL 7.2.1
JDBC1
JDBC2

Sample Code
.....
sTableName = "CUSTOMER";
....
ResultSet columnMetaInfo = dbmeta.getColumns( connection.getCatalog(),
schema,
sTableName,
null );

No file was uploaded with this report