JDBC org.postresql.Driver - Mailing list pgsql-general

From Ian deSouza
Subject JDBC org.postresql.Driver
Date
Msg-id AHj66.1798$Bp.73981@newsread2.prod.itd.earthlink.net
Whole thread Raw
List pgsql-general
Hi All,

I'm wondering if there could be a problem in the JDBC driver.

I'm calling:

preparedStatement.setObject(i, value);

where value is of type Boolean (with value false
below)and created the column associated with that
value as type BIT and I'm getting the following
exception when the preparedStatement is executed.

java.sql.SQLException: ERROR:  zpbit_in: t is not a valid bitstring

 at org.postgresql.Connection.ExecSQL(Connection.java:393)
 at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
 at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
 at
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:
126)
 at Database.insert(Database.java:205) (my code)
...

Any help would be appreciated.

Thanks, Ian





pgsql-general by date:

Previous
From: Jreniz
Date:
Subject: PostgreSQL Client Program
Next
From: Dan Moschuk
Date:
Subject: Re: exit status 26