Unix Technical Forum

AbstracJdbc2ResultSet getColumnIndex throws missing column when using with Hibernate

This is a discussion on AbstracJdbc2ResultSet getColumnIndex throws missing column when using with Hibernate within the pgsql Interfaces jdbc forums, part of the PostgreSQL category; --> Hello, We have a table named as DYSMESSAGES (ID number, FROM varchar(100)...) We use hibernate with postgresql-jdbc-8.2-504 driver and ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces jdbc

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-16-2008, 12:29 AM
Hakan Cunier
 
Posts: n/a
Default AbstracJdbc2ResultSet getColumnIndex throws missing column when using with Hibernate

Hello,



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.



When we change regional settings to English (U.S.A) NO PROBLEM AT ALL.



Then we looked at AbstracJdbc2ResultSet class's getColumnIndex method. It
uses toLowerCase(). So problem is that. It should use
toLowerCase(Locale.ENGLISH).



Because

The field returned from PostgreSql 8.2 is id204_ And toLowerCase() result is
id204_

The field that hibernate requested is ID204_ And toLowerCase() result is
ęd204_ . Because in Turkish I not means small i. The problem is that.



Dear jdbc-driver developer, can you help us about this problem.



Thank you in advance,

Hakan Cunier






Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:49 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com