Re: Bad value for type BigDecimal : Y

From: John Lister <john(dot)lister(at)kickstone(dot)com>
To: Ashish Jain <ashjain2(at)gmail(dot)com>
Cc: Mikko Tiihonen <mikko(dot)tiihonen(at)nitorcreations(dot)com>, richard(dot)broersma(at)gmail(dot)com, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bad value for type BigDecimal : Y
Date: 2009-06-12 07:42:26
Message-ID: 4A3206E2.4070508@kickstone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Ashish Jain wrote:
> Hi Mikko/Richard,
>
> Thanks for your reply. I do have a column whose length is 1. The
> definition goes something like this
> @Column(updatable=true, name="st_spom_status", nullable=false, length=1)
> private String status;
>
> Do you think this is what may be the cause of the problem??
>
My first guess is that you have a column defined as a bigdecimal in your
jpa object but it is actually a string in the database one of whose rows
contains the value 'Y'.

JOHN

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2009-06-12 13:10:13 Re: PreparedStatements with PG specific data types.
Previous Message Ashish Jain 2009-06-12 06:16:43 Re: Bad value for type BigDecimal : Y