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

From Barry Lind
Subject Re: DatabaseMetaData.getTables() problem
Date
Msg-id 3DBEBD72.8060706@xythos.com
Whole thread Raw
In response to DatabaseMetaData.getTables() problem  ("w.winter" <w.winter@logitags.com>)
Responses Re: DatabaseMetaData.getTables() problem  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Wolfgang,

Can you try this test using the 7.3beta3 build of the driver from
jdbc.postgresql.org?  I think this should be fixed in the latest build.

thanks,
--Barry


w.winter wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>




pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: precision of numeric type
Next
From: Dave Cramer
Date:
Subject: Re: Prepared Statement limit ?