It's not a secret anymore!*
The moose likes Developer Certification (SCJD/OCMJD) and the fly likes Best way to check record locking Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Certification » Developer Certification (SCJD/OCMJD)
Bookmark "Best way to check record locking" Watch "Best way to check record locking" New topic
Author

Best way to check record locking

Rolf Johansson
Ranch Hand

Joined: Feb 25, 2004
Posts: 32
I want to make sure that I correctly implement a record locking stategy, satisfying this requirement:

Your server must be capable of handling multiple concurrent requests, and as part of this capability, must provide locking functionality as specified in the interface provided above. You may assume that at any moment, at most one program is accessing the database file; therefore your locking system only needs to be concerned with multiple concurrent clients of your server. Any attempt to lock a resource that is already locked should cause the current thread to give up the CPU, consuming no CPU cycles until the desired resource becomes available

To test this, I instantiate the class Data:

Then I instantiate a class (DBRead) that is derived from class Thread that has the following run method. During instantiation, I specify the Thread's name and what record number I want to read:

Then I instantiate another class (DBCheck) that is derived from class Thread that has the following run method:

I put both these classes in a loop:

Then start 'em up:

If I create enough threads I see records initially locked, then eventually these records get read.
Is this a valid way to simulate many "nearly-concurrent" requests to the database for the same record, in order to validate the record locking algorithm?
Any comments are welcomed.
- Rolf.
Andrew Monkhouse
author and jackaroo
Marshal Commander

Joined: Mar 28, 2003
Posts: 11404
    
  81

Hi Rolf,
The best thing you can do is prove to yourself logically that your locking code is correct. Or even better: have some person who is not involved in this assignment review your lock and unlock methods and prove logically that they work. The testing is then just icing on the cake.
The main things I recommend you look for:
  • What happens if two or more threads try to lock an unlocked record simultaneously?
  • What happens if two or more threads try to lock a locked record simultaneously?
  • What happens when two or more threads are woken up by the notifyAll()?
  • Do your instructions require you to handle the case when someone tries to update a record they don't have locked? If so, do you handle it correctly?


  • But to continue with the idea of testing ...
    One of the tests that was regularly recommended in the Fly By Night Services assignment was decrementing the number of seats in a particular flight. If there are 89 seats available on a flight, and we start 10 threads, each removing 3 seats from the flight, then at the end of the run there should be 2 seats remaining, and one thread complaining that it could not book the three seats. Any other result and there was guaranteed to be a problem somewhere
    You could do something similar with your assignment (even if it is one of the new assignments you can just use the customer field as a temporary holder of numbers).
    Regards, Andrew


    The Sun Certified Java Developer Exam with J2SE 5: paper version from Amazon, PDF from Apress, Online reference: Books 24x7 Personal blog
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: Best way to check record locking
     
    Similar Threads
    Should lock methods be callable by the client
    About:My URLyBird1.3.2 Locking
    NX:what is the magic cookie and what ...?(contrator)
    Waiting for unlock record
    NX: Exception handling implementing the DBAccess