How to do this action by Hibernate world?

hunj · **Joined:** Mon Sep 08, 2003 12:51 am **Posts:** 19

Dear all,

I wonder how to perform this sql by hibernate.

SQL: update person set status = 1 where name='Jack' and status = 0

Best regards,

Jun Huang

michael · **Posted:** Fri Jan 02, 2004 7:42 am

Query the objects you want to manipulate using session.find() and then change the property you want to change. Or use a standard SQL query by obtaining the Database Connection by session.getConnection()

hunj · **Joined:** Mon Sep 08, 2003 12:51 am **Posts:** 19

Thanks, gloeglm

The real thing I want to do is to prevent two processes from modifying the same record at the same moment.

I think the hardcode SQL could achieve my aim could but can session.find perform query and update actions in one sql call?

emmanuel · **Posted:** Fri Jan 02, 2004 10:16 am

Have a look at the optimistic locking and version tag. Hibernate does that for you.