Re: [JDBC] Allow setObject(x,y,Types.BIT) if y is a Number & - Mailing list pgsql-patches

From Kim Ho
Subject Re: [JDBC] Allow setObject(x,y,Types.BIT) if y is a Number &
Date
Msg-id 1056992216.1022.0.camel@topanga.toronto.redhat.com
Whole thread Raw
In response to Re: [JDBC] Allow setObject(x,y,Types.BIT) if y is a Number &  (Barry Lind <blind@xythos.com>)
List pgsql-patches
Oops. Forgot to attach it last time.


On Mon, 2003-06-30 at 12:44, Barry Lind wrote:
> 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
> >
>
>


Attachment

pgsql-patches by date:

Previous
From: Barry Lind
Date:
Subject: Re: [JDBC] Allow setObject(x,y,Types.BIT) if y is a Number &
Next
From: Tom Lane
Date:
Subject: Re: Patch for adding DATACUBE operator