This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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..