| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johnny Luong | 2009-06-12 00:44:07 | PreparedStatements with PG specific data types. |
| Previous Message | Richard Broersma | 2009-06-11 16:46:43 | Re: Bad value for type BigDecimal : Y |