JDBC org.postresql.Driver

Started by Ian deSouzaover 25 years ago1 messagesgeneral
Jump to latest
#1Ian deSouza
iandesouza@earthlink.net

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