On Wed, 2003-06-18 at 13:09, Kim Ho wrote: > Problem: > - setObject(x,y,Types.BIT) throws an exception if y is a Number > - getObject() on a bit column will return null instead of True or False > Boolean objects > Added Problem: - Doesn't set bit columns
> Fix: > - Added check in setObject() to check to that the Number has value==1. > If so, set to True. False otherwise. This seems to be consistent with > the rest of the code. > - Added BIT to JDBC datatype list - Using way to set values in both boolean/bit type columns It works now. The following program works now: Statement stmt = con.createStatement(); stmt.execute("Create Table bit_tab (b bit)"); PreparedStatement pstmt = con.prepareStatement("insert into bit_tab values (?)"); pstmt.setBoolean(1,true); pstmt.execute(); Sorry bout the delay. Cheers, Kim ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match