Locks on multi-user systems
From: Martin Drautzburg <drautzburg_at_altavista.net>
Date: 21 Jan 2002 21:15:03 +0100
Message-ID: <87elkjqx4o.fsf_at_altavista.net>
Date: 21 Jan 2002 21:15:03 +0100
Message-ID: <87elkjqx4o.fsf_at_altavista.net>
I want to inform the first user, that her transaction will not continue due to a lock by the second user, and opt her to rollback.
We have tried the "select for update nowait" method (with Oracle). But this is a hell of programming task. Also to me it does not seem to be bullet proof, when many tables are touched in the same transaction.
Any ideas would be greatly appreciated. Received on Mon Jan 21 2002 - 21:15:03 CET