Re: Bad value for type BigDecimal : Y

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(dot)broersma(at)gmail(dot)com> wrote:

> On Thu, Jun 11, 2009 at 7:01 AM, Ashish Jain<ashjain2(at)gmail(dot)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
>