Re: metadata.getColumns() using Apache Tomcat / jndi

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(at)opencloud(dot)com
> To: beginner_(at)hotmail(dot)de
> CC: danap(at)ttc-cmc(dot)net; pgsql-jdbc(at)postgresql(dot)org
>
> On 3 October 2011 18:00, Thomas Strunz <beginner_(at)hotmail(dot)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