Re: Problem with boolean type

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Johann Robette <jrobette(at)onyme(dot)com>
Cc: 'PostGreSQL JDBC' <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Problem with boolean type
Date: 2004-10-07 20:10:55
Message-ID: 4165A2CF.6050305@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Johann Robette wrote:

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

What is 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

Do you have access to the code that is calling the JDBC driver? Can you
show us that code?

-O

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-10-07 20:22:24 Question about timezones
Previous Message Steven Klassen 2004-10-07 19:52:59 Re: PSQL undesired transaction behavior when connection is lost.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-10-07 20:15:49 Re: Translation updates: errors_ru.properties
Previous Message Scot P. Floess 2004-10-07 18:21:52 Re: where is postgis.jar ?!