Problem with boolean type

From: "Johann Robette" <jrobette(at)onyme(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "'PostGreSQL JDBC'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Problem with boolean type
Date: 2004-10-07 14:47:45
Message-ID: 002401c4ac7c$9e6c33f0$a5010a0a@Johann
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Hi,

I'm using Postgres 8.0 beta 3 and the appropriate JDBC Driver.

I use EJB to create a record in a table containing a Boolean field
"answered".
The EJB method expects a Boolean object so I pass new Boolean(false) in
order to create it as false.

But I get the following error :
java.sql.SQLException: ERROR: column "answered" is of type boolean but
expression is of type text

Any help will be greatly appreciated.

JR

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Schaber 2004-10-07 14:51:20 Re: Avoiding explicit addDataType calls for PostGIS
Previous Message Bruno Wolff III 2004-10-07 14:34:46 Re: Random not so random

Browse pgsql-jdbc by date

  From Date Subject
Next Message Markus Schaber 2004-10-07 14:51:20 Re: Avoiding explicit addDataType calls for PostGIS
Previous Message Kris Jurka 2004-10-07 13:58:26 Re: where is postgis.jar ?!