Hi,
I would like to get som input on how to handle the following scenario:
-
Thread 1 locks record 5
- Thread 2 tries to lock record 5 (goes into waiting state)
- Thread 3 tries to lock record 5 (goes into waiting state)
- Thread 1 deletes record 5
Even if the delete-method would unlock and notify on record 5, only one of Thread 2/3 would wake up, and the other one would be waiting for ever.
How have you handled this?
Thanks, Jim