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

Whats wrong with SQL/JDBC?

This will be a feature in Hibernate3

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