Skip site navigation (1) Skip section navigation (2)

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

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #674: JDBC: DatabaseMetaData.getColumns() "feature"
Date: 2002-05-23 14:41:20
Message-ID: 20020523144120.4E5DC475F22@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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


pgsql-bugs by date

Next:From: Tom LaneDate: 2002-05-23 14:43:13
Subject: Re: Numeric Datatype
Previous:From: Tom LaneDate: 2002-05-23 14:21:29
Subject: Re: in(NULL)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group