Session session = getSession(); session .createSQLQuery( "update SOME_TABLE set SOME_LEVEL=:newLevel where SOME_LEVEL>:newLevel and OTHER_ID=:otherId") .setParameter("newLevel", myNewLevel).setParameter( "otherId", myFoo.getId()).executeUpdate();