|Subject||Re: [firebird-support] Re: Deadlock exception occurs but it shouldn't?|
|Author||Walter R. Ojeda Valiente|
On Wed, Dec 24, 2014 at 10:39 AM, brucedickinson@... [firebird-support] <firstname.lastname@example.org> wrote:
Thank you Hugo, I was bit reluctant to use WITH LOCK since documentation discourages its usage.
I've tried it but it did not help.
"The main purposes of explicit locks are (1) to prevent expensive handling of update conflict errors in heavily loaded application"
this is the exact reason I try to avoid conflicts. My threads can wait but they should not raise exceptions.
I always though that it is possible to avoid such conflicts on the database level.