Application deadlock example

Some developers simulate cursors by using two or more connections from DB-Library™. One connection performs a select and the other connection performs updates or deletes on the same tables. This can create application deadlocks. For example:

Since Connection A never requests a lock that is held by Connection B, this is not a server-side deadlock.