Hi,

How can I make hibernate perform a Query such as the following:

"Update [versioned] MyEntity set MyProperty = (MyProperty + 3) where ... "

I don't really want to do it in the Java code, since then I'll get into concurrency issues (dirty writes). I Simply want the DBMS to handle the transaction management for me.

Is it possible at all?

*[versioned] - I might want the change to reflect in the in-memory entities.

Thanks.

I managed to make it generate the SQL query

update MyEntity set prop = (prop - ?) where ..)

It bind the right values where it should but it does not execute the update
for some reason.