The following bug has been logged online:
Bug reference: 1646
Logged by: Kjh
Email address: kjh@networks.nera.no
PostgreSQL version: 8.0
Operating system: windows XP
Description: ERROR: column "mycolumn" is of type boolean but
expression is of type character
Details:
newest drivers (JDBC3)
deployed it with JBoss 3.2.6
Indeed, the entity bean has fields of java-type Boolean and the database has
fields of type boolean, but the application server seems to send it to the
database as "true" or "false" strings. That is what the errormessage
indicates to me anyway: ERROR: column "mycolumn" is of type boolean but
expression is of type character. (Though I am not aware of how to verify
this other than changing column type varchar(5) which I have tried -
unfortunately, this had lots of other undesired side-effects even though it
worked in some cases.)
Entity beans with Boolean types works fine with mysql and mssql, though with
the BIT type in the database, instead of boolean. However, if I try to use
the BIT type, I bump into another error: My data base SEED TOOL fails to
load data with the following error ERROR: column "mycolumn" is of type bit
but expression is of type boolean
sigh(!)
please help.
Kjetil