Skip site navigation (1) Skip section navigation (2)

Re: Bad value for type BigDecimal : Y

From: Mikko Tiihonen <mikko(dot)tiihonen(at)nitorcreations(dot)com>
To: Ashish Jain <ashjain2(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bad value for type BigDecimal : Y
Date: 2009-06-11 16:52:23
Message-ID: 4A313647.2020705@nitorcreations.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Ashish Jain wrote:
> Hi,
> 
> I am using postgresql 8.3 with openJPA 1.2.1. I hit the following error
> 
> org.postgresql.util.
> PSQLException: Bad value for type BigDecimal : Y
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBigDecimal(AbstractJdbc2ResultSet.java:311)
>     at 
> org.tranql.connector.jdbc.ResultSetHandle.getBigDecimal(ResultSetHandle.java:179)
>     at 
> org.apache.openjpa.lib.jdbc.DelegatingResultSet.getBigDecimal(DelegatingResultSet.java:282)
>     at 
> org.apache.openjpa.jdbc.sql.DBDictionary.getBigDecimal(DBDictionary.java:389)
>     at 
> org.apache.openjpa.jdbc.sql.PostgresDictionary.getInt(PostgresDictionary.java:210)
>     at 
> org.apache.openjpa.jdbc.sql.DBDictionary.getChar(DBDictionary.java:556)
>     at 
> org.apache.openjpa.jdbc.sql.ResultSetResult.getCharInternal(ResultSetResult.java:288)

Do you store a boolean 'Y'/'N' in a char(1) column? Maybe openjpa needs to have 
a different mapping that char for it.

-Mikko


In response to

Responses

pgsql-jdbc by date

Next:From: Johnny LuongDate: 2009-06-12 00:44:07
Subject: PreparedStatements with PG specific data types.
Previous:From: Richard BroersmaDate: 2009-06-11 16:46:43
Subject: Re: Bad value for type BigDecimal : Y

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group