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 (?)");

Sorry bout the delay.



---------------------------(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

Reply via email to