Re: [JDBC] AbstracJdbc2ResultSet getColumnIndex throws missing column when using with Hibernate

From: Kris Jurka <books(at)ejurka.com>
Date: Tue Feb 19 2008 - 01:14:13 EST

On Thu, 4 Jan 2007, Hakan Cunier wrote:

> We have a table named as DYSMESSAGES (ID number, FROM varchar(100)...)
>
> We use hibernate with postgresql-jdbc-8.2-504 driver and PostgreSQLDialect.
> Our hql is "from Dysmessages".
>
> Hibernate convert this hql to "select dysmessage0.ID as ID204_,
> dysmessage0.FROM as FROM204_ from DYSMESSAGES dysmessage0" native sql
> format.
>
> Our jvm Works on Jboss / Windows XP Pro Turkish / Turkish Regional Settings
>
> Hibernate throws exception as no column found named as ID204_ in this
> resultset.
>
> Then we looked at AbstracJdbc2ResultSet class's getColumnIndex method. It
> uses toLowerCase(). So problem is that. It should use
> toLowerCase(Locale.ENGLISH).
>

Fixed in CVS and backpatched to 8.0.

Kris Jurka

---------------------------(end of broadcast)---------------------------

TIP 6: explain analyze is your friend Received on Tue Feb 19 01:16:42 2008