Re: Allow setObject(x,y,Types.BIT) if y is a Number &

Kim,

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
>