DatabaseMetaData.getTables() problem - Mailing list pgsql-jdbc

From w.winter
Subject DatabaseMetaData.getTables() problem
Date
Msg-id 002f01c27d9e$e49e0060$667ba8c0@panzerknacker
Whole thread Raw
List pgsql-jdbc
Hi,

on testing our auto-configuration persistence framework ACP against
PostgreSQL we found the following problem:

There is a table A625431658_Person1, created as quoted mixed case
identifier.

I do:
databaseMetaData.getTables(null, null, "%", new String[] {"TABLE"})
--> A625431658_Person1 is in the ResultSet. OK.

I do:
databaseMetaData.getTables(null, null, "A625431658_Person1", new String[]
{"TABLE"})
--> A625431658_Person1 is NOT in the ResultSet.

I do:
databaseMetaData.getTables(null, null, "%erson1", new String[] {"TABLE"})
--> A625431658_Person1 is in the ResultSet. OK.

Seems there is a problem with mixed case ?


Wolfgang

___________________
Dr. Wolfgang Winter
LogiTags Systems
www.logitags.com


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: getTables()
Next
From: "w.winter"
Date:
Subject: Supplement