Hi,

Sometimes, we just want to update maybe 1 column value instead of 3 columns of a table.

Say the table has name, address, contact.

How should I specify my update statement in mapping file cos sometime I just want to update address, sometimes I just want to update the contact. Meaning depends on the condition, only certain columns should be updated.

How to achieve this? If use <sql-update></sql-update> then we have to fix the update statement. I'm new to hibernate, please advise.

Thank you.

In your mapping file set dynamic-insert=true and potentially dynamic-update=true:

http://www.hibernate.org/hib_docs/v3/re ... tion-class

Hibernate will then dynamically generate only and insert or update statement with only the changed properties.

Ryan-