Re: Effective deadlock handling

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 05 Jan 2004 08:18:03 -0800
Message-ID: <1073319396.692027@yasure>

Galen Boyer wrote:

> On Sun, 04 Jan 2004, damorgan_at_x.washington.edu wrote:
>
>

>>I always code it with SKIP LOCKED and trap the PK of any missed
>>records for later processing.

>
>
> So, the application can have logic producing deadlock conditions
> but you put a little bit of dressing on the code so the
> application doesn't experience the deadlock error.
>

One could say the same thing about EXCEPTION WHEN OTHERS too.

Just a matter of perspective. From my experience ... at least 50% of good code is defensive in nature.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Jan 05 2004 - 10:18:03 CST