how to do 'select...for update' sql queries

ittay · **Joined:** Wed Jul 14, 2004 11:38 am **Posts:** 3

hi,

i'd like to know if there is a way of running 'select...for update' queries

thanx,
ittay

anthony · **Posted:** Wed Jul 14, 2004 12:36 pm

read the reference doc

anthony · **Posted:** Wed Jul 14, 2004 12:40 pm

You may also load an objects using an SQL SELECT ... FOR UPDATE. See the next section for a discussion of Hibernate LockModes.

Cat cat = (Cat) sess.get(Cat.class, id, LockMode.UPGRADE);
Note that any associated instances or contained collections are not selected FOR UPDATE.

http://www.hibernate.org/hib_docs/refer ... gdata.html