Re: Q: Commit hangs when multiple Select 4 Updates taking place?

From: Sebastiano Pilla <etechweb_at_yahoo.com>
Date: Sun, 6 Oct 2002 15:47:34 +0200
Message-ID: <1fjmocw.1btdq2b1c48xbqN%etechweb@yahoo.com>

<kennethkoenraadt_at_no-spam.hotmail.com> wrote:

> Look in the alert log for deadlock messages. Sounds just like it.
>
> The FOR UPDATE will lock the row(s). That is a potential source of
> deadlocks, and your application should deal with them.

In addition to what Kenneth says, try investigating the "FOR UPDATE ... NOWAIT" alternate syntax for your queries. Your application should still be prepared for the case when a row is locked by another application, but it should now return immediately and alert the user.

Sebastiano Pilla Received on Sun Oct 06 2002 - 08:47:34 CDT