Re: Bad value for type BigDecimal : Y

[Ashish Jain <ashjain2(at)gmail(dot)com>]

John/Mikko/Richard,

Thanks a lot for all your help on this issue.
I was able to resolve this problem by setting the following property
<property name="openjpa.jdbc.DBDictionary"
value="postgres(StoreCharsAsNumbers=false)"/>

Thanks
Ashish

On Fri, Jun 12, 2009 at 1:12 PM, John Lister <john(dot)lister(at)kickstone(dot)com>wrote:

> 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
>
>