Hi,

Let's say I have this model class:
class Doc {
String name;
Blob content;
}

Every time I update the Doc entity with ONLY the name field value changed, apparently it updates (flushes) the content to the database as well. Since I index the content field, this will make the index out-of-sync.

I've read others having similar problem with the version being updated but couldn't find anyone have the exact problem as mine.

Besides remove the Blob content field to another table. How can I make sure Hibernate does NOT update the Blob field when it's not changed.

I verified this by specify update="false" and no problem.

Hibernate version: 3.2.2GA
Oracle 10g R2

Thanks,
Frank

Hi,
>>> How can I make sure Hibernate does NOT update the Blob field when it's not changed.

Try, dynamic-update="true" for the class.
This ensures that only modified columns are included in update query.

---------------------------------------------------------------
Rate the reply if you find it helpful

Hi,

This does not exactly answer all my questions but thanks very much since I overlooked this option.

--Frank