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..