I'm trying to let Hibernate update multple objects, this could be done by the follow update query:

UPDATE `tablename` SET `amount` = `amount` * x WHERE ...;

What is the best way to this in Hirbernate. I know i can't use session.createSqlQuery(), that's only for selects.

Thanx in advance.

begin trans
first load all objects,
then update objects (setter)
last commit

Yes this works indeed, it seems a little 'overkill' if i see the amount of source code. But that can also be my own fault (how i wrote it). Be i think i go for this method. Thanks for your help.

if it is massive update, you can also get jdbc connection and do it in pure jdbc to save performance but be extremelly carefull with the session state and cache