Re: Bad value for type BigDecimal : Y

Поиск
Список
Период
Сортировка
От Ashish Jain
Тема Re: Bad value for type BigDecimal : Y
Дата
Msg-id 14af40510906112316q67c62e2eu5dae171911bac1a1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bad value for type BigDecimal : Y  (Mikko Tiihonen <mikko.tiihonen@nitorcreations.com>)
Ответы Re: Bad value for type BigDecimal : Y
Список pgsql-jdbc
Дерево обсуждения
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??
 
Thanks
Ashish

On Thu, Jun 11, 2009 at 10:22 PM, Mikko Tiihonen <mikko.tiihonen@nitorcreations.com> wrote:
Ashish Jain wrote:
Hi,

I am using postgresql 8.3 with openJPA 1.2.1. I hit the following error

org.postgresql.util.
PSQLException: Bad value for type BigDecimal : Y
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBigDecimal(AbstractJdbc2ResultSet.java:311)
   at org.tranql.connector.jdbc.ResultSetHandle.getBigDecimal(ResultSetHandle.java:179)
   at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getBigDecimal(DelegatingResultSet.java:282)
   at org.apache.openjpa.jdbc.sql.DBDictionary.getBigDecimal(DBDictionary.java:389)
   at org.apache.openjpa.jdbc.sql.PostgresDictionary.getInt(PostgresDictionary.java:210)
   at org.apache.openjpa.jdbc.sql.DBDictionary.getChar(DBDictionary.java:556)
   at org.apache.openjpa.jdbc.sql.ResultSetResult.getCharInternal(ResultSetResult.java:288)

Do you store a boolean 'Y'/'N' in a char(1) column? Maybe openjpa needs to have a different mapping that char for it.

-Mikko


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