Postgres Pro
Downloads
Home   >   mailing lists

Problem with boolean type - Mailing list pgsql-jdbc

From Johann Robette
Subject Problem with boolean type
Date
Msg-id 002401c4ac7c$9e6c33f0$a5010a0a@Johann
Whole thread Raw
In response to Re: Avoiding explicit addDataType calls for PostGIS  (Markus Schaber <schabios@logi-track.com>)
Responses Re: Problem with boolean type  (Kris Jurka <books@ejurka.com>)
Re: Problem with boolean type  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: table and column's comments
Next
From: Markus Schaber
Date:
Subject: Re: Avoiding explicit addDataType calls for PostGIS