Postgres Pro
Downloads
Home   >   mailing lists

Re: Bad value for type BigDecimal : Y - Mailing list pgsql-jdbc

From Ashish Jain
Subject Re: Bad value for type BigDecimal : Y
Date
Msg-id 14af40510906110939o540ea10cl1632e47278f0af98@mail.gmail.com
Whole thread Raw
In response to Re: Bad value for type BigDecimal : Y  (Richard Broersma <richard.broersma@gmail.com>)
Responses Re: Bad value for type BigDecimal : Y
List pgsql-jdbc
Tree view
Hi Richard,
 
Thanks for your reply!!

None of the fields are defind as Big Decimal.I have integer, character and timestamp as the variable types in my SQL statments
Thanks
Ashish
On Thu, Jun 11, 2009 at 10:00 PM, Richard Broersma <richard.broersma@gmail.com> wrote:
On Thu, Jun 11, 2009 at 7:01 AM, Ashish Jain<ashjain2@gmail.com> wrote:

> 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     at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.toBigDecimal(AbstractJdbc2ResultSet.java:2710)

I'm curious what the column definition is for the mapped field that is
defined as a BigDecimal in your JPA ORM.  Is it possible for
PostgreSQL's numeric data to represent values that exceed the limits
of java BigDecimal class?


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-jdbc by date:

Previous
From: Richard Broersma
Date:
Subject: Re: Bad value for type BigDecimal : Y
Next
From: Richard Broersma
Date:
Subject: Re: Bad value for type BigDecimal : Y