I hope this is the right place for this...
I want to implement java program to use a mysql DB, and need to make sure of a few things first.
Is it possible to lock a record when it is being written to, and if another process attempts to write to the same record, they can be notified that it is locked, so they can just read the record instead?
Ive read alot of the JDBC tutorials, and cant find if this is possible. I know you can lock a record, and a process will wait until it becomes 'unlocked' but I need to be able to find out if it is locked or not.
Thanks for any help