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
