Well from what I can tell is that when the application executes several
commands in a row very quickly I get the deadlock error. The type of command
I am executing on is a Stored Procedure that accesses several tables at
once. Should I change the Stored procedure into a View? So I can duplicate
the error by executing very short executing statements one after the other.
John Smith
----- Original Message -----
From: "Jiri Cincura" <[EMAIL PROTECTED]>
To: "For users and developers of the Firebird .NET providers"
<firebird-net-provider@lists.sourceforge.net>
Sent: Tuesday, October 03, 2006 3:34 PM
Subject: Re: [Firebird-net-provider] deadlock
> John Smith wrote:
>> Well the application that I have developed is a multi threaded
>> application
>> that is continuously executing SQL Commands. Are commands automatically
>> committed once the dispose command is called?
>
> If you use default transaction, then yes.
>
> BTW your problem description doesn't contain a lot of information.
> What type of commands you're executing? Are there operating on same table?
> Are there operating synchronously? Happening this every time or only
> sometimes? Are you able to reproduce the problem on small example, which
> we
> can see to better help you? ...
>
> --
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
