Thread: JDBC driver converts search string patterns to lowercase

JDBC driver converts search string patterns to lowercase

From
pgsql-bugs@postgresql.org
Date:
Bjorn Peterson (petbjo@bethel.edu) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
JDBC driver converts search string patterns to lowercase

Long Description
The metadata class of the Postgresql 7.1 JDBC driver converts search string patterns to all lowercase.  This means that
ifI want to use metadata.getColumns(null,null,tableName,"%") for example, the tableName will be converted to all
lowercase,and will not match if my table names have any capital letters.  I tried quoting the table names, but that
didn'twork either.  I see no reason for the names to be converted to lower case, and it is extremely inconvenient to
codea work-around for this. 

Sample Code


No file was uploaded with this report