Exception in Boolean to int2 conversion in xwiki??

From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Exception in Boolean to int2 conversion in xwiki??
Date: 2005-10-10 05:22:03
Message-ID: 1128921723.6292.23.camel@Panoramix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I get the following exception while using xwiki and PostgreSQL, which
originates in the PostgreSQL jdbc driver according to the stacktrace:

2005-10-10 06:03:24,657 ERROR [org.hibernate.util.JDBCExceptionReporter]
Batch entry 0 update xwikiclassesprop set XWP_PRETTYNAME=Skin,
XWP_CLASSTYPE=com.xpn.xwiki.objects.classes.StringClass,
XWP_UNMODIFIABLE=0, XWP_NUMBER=1 where XWP_ID=104408758 and
XWP_NAME=skin was aborted. Call getNextException to see the cause.
2005-10-10 06:03:24,657 WARN [org.hibernate.util.JDBCExceptionReporter]
SQL Error: 0, SQLState: 42804
2005-10-10 06:03:24,657 ERROR [org.hibernate.util.JDBCExceptionReporter]
ERROR: column "xwp_unmodifiable" is of type smallint but expression is
of type boolean

Does this mean that it is not possible to convert a Java Boolean to a
PostgreSQL int2 according to the driver or am I reading the exception
text wrong?

If I am reading the exception text correct, doesn't the JDBC spec
specify a mapping from Boolean to smallint (according to Appendix B,
table B-5)?

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-10-10 06:26:03 Re: Exception in Boolean to int2 conversion in xwiki??
Previous Message Oliver Jowett 2005-10-08 09:47:14 Re: Still baffled by a CONNECTion problem