Hi Oliver,
oh my god you are right. postgresql is the only one of these RDBMS that is case-sensitive.
configuration files are different for the 2 cases eg. tableName vs. tablename.
I ran into "issues" with this before and actually made myself a note "PostgreSQL is case-sensitive" and now I still forgot about that...
thanks for your help.
> Date: Mon, 3 Oct 2011 18:39:39 +1300
> Subject: Re: [JDBC] metadata.getColumns() using Apache Tomcat / jndi
> From: oliver@opencloud.com
> To: beginner_@hotmail.de
> CC: danap@ttc-cmc.net; pgsql-jdbc@postgresql.org
>
> On 3 October 2011 18:00, Thomas Strunz <beginner_@hotmail.de> wrote:
>
> > Anway I changed the command to "metaData.getColumns(null, null,
> > molTableName, "%");". Behaviour remains exactly the same. this works for MS
> > SQL, MySQL and HSQLDB but not for postgresql. Meaning there must be a bug
> > somewhere.
>
> Have you confirmed that the table name you are passing really is the
> same in both cases?
>
> Failing that, I suggest you log the query on the server side and see
> what's happening differently.
>
> Oliver