Hello All!

I created entity with 2 BLOB columns in one table: one for image and one for thumbnail. Storing image and getting it back in another session works pretty good.

But when I set thumbnail BLOB successfully, the original BLOB becomes empty. Retrieved entity returns length 0 for image BLOB.

@Lob private Blob image;
@Lob private Blob thumbnail;

Hibernate 3.2.6, Annotations 3.3.0, PostgreSQL 8.3.1, JDBC 8.3-603.
The problem is 100% reproducible. Please, help?

P.S. The same code works fine on Derby, H2, MySQL and MS SQL.

It looks like raw JDBC access to created table works fine.

Tracing in debugger shows that during Session.flash UPDATE "image" column OID (BLOB reference) is changed to another (e.g. was 85781, became 85782), but blob data can still be referenced by old OID.

You might have to define a trigger for update/delete. I'm not an expert, but search for "lo_manage" function and "trigger" keywords on the web to get more info on that.
Here's my problem though:
https://forum.hibernate.org/viewtopic.php?f=1&t=1005584