Hibernate version:
2.1.6
Database:
Oracle 9.2.05

Hi
I have following problem.
We have object Contract that maps to Contract table. This object and table has around 60 columns. We process this table in following sequence:
- we read this column to Contract object
- we modify attributes in this object
- and we call hibernate update method for this object.

We have notice that Hibernate try to update all columns in database not only these columns that were updated. It is not good because when few rows are updatated (even if values are not changed) DB engine tries to rebuild indexes that were created on this columns.

How to enforce that only changed attributes will be updated ?

Regards
Michal

use dynamic-update

I'm having the same problem. Whenever I do a updateOrSave, it will update every object in the collection. I try to use the dynamic-update on the class, but that doesn't seem to make any difference. Please let me know if anyboday make it to work. Thanks.

Does not work for detatched objects - probably will in combination with select-before-update=true

But a select-before-update will probably give poor performance. I'm wondering if there is a way that I can set a flag on the element of the collection, and hibernate detemine if the element needs to be update or not base on the flag that I set, or some interface I can implement with my class to do that? Thanks.

Can you tell me what do you mean by deattached object? Thanks.