Hibernate version: 2

Name and version of the database you are using: Oracle 9.2


Hi,
I am inserting several rows of data (a set of Objects), each row having a BLOB field in a single transaction .

All of the data is inserted correctly, with the exception of some BLOB fields not being inserted.

I have checked the hibernate log, and from the insert statement it seems that the BLOB is inserted properly (The long, long string of binary).

No errors were thrown.

The mapping is similar to the one in this article : http://www.hibernate.org/73.html


Thank you for your help in advance

Hi,


I have migrated to Hibernate 3.1.3 but the problem still persists.

Upon some investigation, I have further information to add.

I am actually trying to insert a set of objects, which contain a BLOB field each. The objects might or might not have a BLOB to insert.

Looking at the insert statements, I have found something peculiar.
For example, I might insert 5 objects, of which 1 will have no BLOB.

If the insertion order is like this :
Object 1 - with BLOB
Object 2 - with BLOB
Object 3 - without BLOB
Object 4 - with BLOB
Object 5 - with BLOB

Objects 4 and 5 will have the BLOB not inserted. It seems that objects that are inserted after the object without the BLOB will have their own BLOB not inserted.

In other tests I ran, I might insert 10 objects, all of which have BLOBs. All are able to be inserted.


Any ideas, anyone?