Subject Re: [firebird-support] Re: Lock conflict on no wait transaction
Author Helen Borrie
At 01:06 PM 7/07/2005 +0000, you wrote:
>Yes,
>
>Of course you are right.
>It is two writers, I realized that after I posted my message.
>Right now I am working the steps that David proposed.

Sven, for your mental health and the integrity of your database, I strongly
urge you to ignore David's advice. Fix up your app so that it anticipates
and HANDLES lock conflicts - which are the database engine's totally
*intended* response when there is contention for an update.

Sorry, David, but your posting is 100% "up the spout". You clearly need to
get your head around how the multiversioning engine works, why lock
conflicts occur (and why you should WELCOME them!) and -- key to the whole
-- what consititutes an atomic database application task...

./heLen