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