Hi Marco.
Thanks for the workaround.
Laurent
On Thu, 2002-11-21 at 16:26, Paskamp, Marco wrote:
> Hello,
> this is a kernel bug and will be fixed within the next release. No time schedule by
>now. Thank you for reporting the bug. A possible workaround is setting the NULL-value
>as parameter:
>
> PreparedStatement ps = this.connection.prepareStatement("UPDATE LongNull SET Blob2
>= ?, Blob1 = ? WHERE ID = 1");
> ps.setString(1, "homer");
> ps.setNull(2, java.sql.Types.CLOB);
> ps.executeUpdate();
>
> Regards,
> Marco Paskamp
> ----------------------------------------------
> Marco PASKAMP
> SAP DB, SAP Labs Berlin
>
> > -----Original Message-----
> > From: Laurent Vaills [mailto:[EMAIL PROTECTED]]
> > Sent: Mittwoch, 20. November 2002 18:57
> > To: [EMAIL PROTECTED]
> > Subject: JDBC : bug when updating BLOBS
> >
> >
> > Hi.
> >
> > When I want to update a row in which I set a blob value as NULL the
> > update fails but the executeUpdate does not return an incorrect value.
> >
> > I tested it with the latest value of the JDBC driver (7.4.04.00a).
> >
> > Please find a test file that shows this bug.
> > The only difference between the method updateBlobNull() and
> > update() is
> > that in update() both blob are set to non null values but in
> > updateBlobNull Blob1 is set to NULL.
> >
> > Tell me if you have any work around.
> >
> > Regards,
> > Laurent
> >
> >
> >
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
