Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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'.


In response to


pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group