locking a table

maxzilla · **Posted:** Tue Jul 11, 2006 5:25 am

Hi,

Is there anyway i can tell hibernate to lock the table it's reading? i don't want any other transactions doing an insert or update on the table when the transaction owning the lock is still active.

please , any help would be appreciated..

Thanks

Max

robbobkirk · **Joined:** Tue Sep 27, 2005 11:03 am **Posts:** 6

Query q = session.createQuery("from Entity as entity");
q.setLockMode("entity", LockMode.UPGRADE);

(see setLockMode for more help)

Rob

batmat · **Posted:** Tue Jul 11, 2006 9:06 am

Yes, or

Code:

session.lock(enEntity, LockMode.READ); //for example

http://www.hibernate.org/hib_docs/v3/re ... e-detached