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: 4A3206E2.4070508@kickstone.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group