Ali Awan wrote:
Every once in a while on my intranet application I get Database errors.
MS SQL Server will throw an error that the transaction was deadlocked.
It happens around a piece of code in which I have 2 queries, an Update and a
Delete which are nested inside a CFTransaction.
On
Yes and no.
In one case, I found concurrent queries and I also found 2 sessions hitting the
same table.
Did you find any concurrent queries?
For a deadlock you need at least two SQL sessions hitting the same object.
It is not unlikely this can deadlock, but to be certain we need to see
the
Ali Awan wrote:
In one case, I found concurrent queries and I also found 2 sessions hitting
the same table.
If the concurrent queries do not lock the records in the same order as
the transaction does, that can cause deadlocks.
It is not unlikely this can deadlock, but to be certain we
What kind of lock are you doing?
Scope/name/exclusive?
..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 08,
Ben,
I'm doing an exclusive lock.
What kind of lock are you doing?
Scope/name/exclusive?
.
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
~|
Deploy Web Applications Quickly across
5 matches
Mail list logo