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