Re: How to use JDBC to update LargeObject

On Thu, 21 Jan 2010, Satish Burnwal (sburnwal) wrote:

> Even setBlob() method seems to be updating large object only partially.

If you want to reuse an existing blob you need to truncate it first:

http://java.sun.com/javase/6/docs/api/java/sql/Blob.html#truncate(long)

Note that there is a bug with truncate in all but the CVS JDBC drivers
that prevents you from truncating a blob to zero length.  Released
drivers can only truncate down to one byte, but that's probably fine for
you at the moment.

Kris Jurka