setBoolean with BIT column

Hi,

I am using PostgreSQL 7.2 and have a column of type BIT that I am 
inserting into with a PreparedStatement.  In reading the Javadoc for 
PreparedStatement, the setBoolean() method seems to be the correct way 
to set a parameter for a BIT datatype as the description for the method is:

"Sets the designated parameter to the given Java boolean value.  The 
driver converts this to an SQL BIT value when it sends it to the database."

When I try this though, I get an error:

"cannot parse t as a binary digit"

In looking at the PreparedStatement's SQL, it seems to be constructing 
something like:

insert into myTable values('t')

which would explain the error message.

So, is this a bug in the JDBC driver in that it doesn't do the 
conversion to an SQL BIT value when sent to the database like the 
Javadoc says?  If not, what is the correct way to set a parameter to a 
BIT value in a PreparedStatement?

I know I can probably use a BOOLEAN column and things will work fine, 
but I expected this to work using a BIT datatype.

Thanks,

Kevin


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster