Are you going to be submitting a patch for this?
thanks, --Barry
Kim Ho wrote:
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 7: don't forget to increase your free space map settings
---------------------------(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