JDBC org.postresql.Driver
Started by Ian deSouzaover 25 years ago1 messagesgeneral
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