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: (view raw, whole thread or download thread mbox)
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

Sample Code
sTableName = "CUSTOMER";
ResultSet columnMetaInfo = dbmeta.getColumns( connection.getCatalog(),
                                              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-2017 The PostgreSQL Global Development Group