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