I am using Hibernate with Spring and most of the time I use getHibernateTemplate to perform save/update. However I am facing a problem where I have to execute this query:
Code:update user set score = 5 where score = :oldScore
Where oldScore is 3
What is the best way to execute this? Do I need to use Spring's JDBCTemplate()? I also looked at HibernateCallback but don't know how to make it execute such query.