File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Hibernate - Locking a record Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate - Locking a record" Watch "Hibernate - Locking a record" New topic

Hibernate - Locking a record

Meet Gaurav
Ranch Hand

Joined: Oct 08, 2008
Posts: 492

I have reservation site, in that i have some set of numbers loaded in table. During reservation am fetching records one by one and updating the status as reserved.

While selecting the record am using a lock(for update) and then updating the status as reserved. In real time because of the load 2 diff threads picking the same record and second one is while update. since I have selected the record with lock.

Could someone please suggest is there any way I can restrict the record from the select which is already selected with lock..
I agree. Here's the link:
subject: Hibernate - Locking a record
It's not a secret anymore!