> (1) Re-write the "SELECT...FOR UPDATE" SQL code, to> return with an exception or error if it cannot immediately> secure the lock, OR:
You could use SET STATEMENT_TIMEOUT...
Chris