Bulk field updates

chbvsprasad · **Joined:** Fri Oct 15, 2004 9:58 pm **Posts:** 25

Is there any way to update a field of an object without fetching that object into the memory. I want to write queries like

1) update ... abc where abc.z>0
2) update .. select...

Any help would be great.

Prasad

christian · **Posted:** Sat Oct 16, 2004 3:41 am

Whats wrong with SQL/JDBC?

steve · **Posted:** Sat Oct 16, 2004 9:14 am

This will be a feature in Hibernate3

chbvsprasad · **Joined:** Fri Oct 15, 2004 9:58 pm **Posts:** 25

Thanks Steve. If the syntax is available could you point me to that place?

Christian,

There is nothing wrong with JDBC/SQL, but I want to minimize the use of SQL in our code. There are large number of queries (1000s) in our app and maintainance would be hard if both SQL and HQL queries are mixed all over the place. Another reason is that the coupling between our persistence layer and the underlying schema would increase. It is hard to eliminate SQL altogether (for performance reasons) but I want to minimize those instances.

Thanks,
Prasad