Re: Bad value for type BigDecimal : Y

Поиск
Список
Период
Сортировка
От Ashish Jain
Тема Re: Bad value for type BigDecimal : Y
Дата
Msg-id 14af40510906160122t60d30e48r828cb8acf7804bd0@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bad value for type BigDecimal : Y  (John Lister <john.lister@kickstone.com>)
Список pgsql-jdbc
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.lister@kickstone.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


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Testing - ignore.
Следующее
От: Ashish Jain
Дата:
Сообщение: prepared transaction with identifier "1197822575_XAAAAAAAAABHVE1JRAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==_AQAAAAAAAABHVE1JRAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==" does not exist