Re: [JDBC] Problem with boolean type - Mailing list pgsql-general

From Kris Jurka
Subject Re: [JDBC] Problem with boolean type
Date
Msg-id Pine.BSO.4.56.0410071017190.14222@leary.csoft.net
Whole thread Raw
In response to Problem with boolean type  ("Johann Robette" <jrobette@onyme.com>)
List pgsql-general

On Thu, 7 Oct 2004, Johann Robette wrote:

> 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

I don't see how that could be happening.  The attached test works fine for
me and exercises every way I see to set a boolean.  Perhaps the EJB is
internally converting this to a setString() call?  Could you investigate
more into what actual driver calls are being made?

Kris Jurka

Attachment

pgsql-general by date:

Previous
From: "David Bitner"
Date:
Subject: regular expression searches
Next
From: "Net Virtual Mailing Lists"
Date:
Subject: Index problem.... GIST (tsearch2)