BUG #2884: Bug in rs.getInt(colname) when JMV language is Turkish

From: "Ismail Cansiz" <icansiz(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2884: Bug in rs.getInt(colname) when JMV language is Turkish
Date: 2007-01-12 09:05:16
Message-ID: 200701120905.l0C95GkL039193@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2884
Logged by: Ismail Cansiz
Email address: icansiz(at)gmail(dot)com
PostgreSQL version: 8.2
Operating system: Centos Linux
Description: Bug in rs.getInt(colname) when JMV language is Turkish
Details:

I have run a query in java:
Here is some part of my java code:
----------------------------------------

sql="SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE
SEQ_NAME='ServerHitBin'";

rs=stmt.executeQuey(sql)

boolean gotVal1 = false;
if (rs.next()) {
val1 = rs.getInt("SEQ_ID");
gotVal1 = true;
}
rs.close();

if (!gotVal1) {
......

This code runs properl when JMV language is en_US.
But when JMV language is tr_TR, occured error.
When i changed the column name to lowercase
val1 = rs.getInt("seq_id");
runs properly.

Here error messages:
---------------------------------------------------

SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='ServerHitBin'
Error was:Bu ResultSet iinde SEQ_ID stun ad bulunamad.
Exception: org.postgresql.util.PSQLException
Message: Bu ResultSet iinde SEQ_ID stun ad bulunamad.
---- stack trace
---------------------------------------------------------------
org.postgresql.util.PSQLException: Bu ResultSet iinde SEQ_ID stun ad
bulunamad.
org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSe
t.java:2450)
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.ja
va:2312)
org.ofbiz.minerva.pool.jdbc.ResultSetInPool.getInt(ResultSetInPool.java:517)

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim GUNDUZ 2007-01-12 10:02:28 Re: BUG #2879: RPM: wrong quoting of error message about
Previous Message Ravi Periasamy 2007-01-12 04:37:04 Re: BUG #2882: jdbc driver: date returned from a stored proc is incorrect