Thread: Timeout for lock table

Timeout for lock table

From
"Jonathan Man"
Date:
Dear All,
 
I begin a transaction. I then execute a SQL command "SELECT FOR UPDATE" to lock some records on the first session. Besides, I also lock some rows using the same method on the second session. Is it possible to return an error message to indicate that some records were locked by another user when I lock it on the second session?
 
Please help me, THX!!
 
 
JMAN