Re: Effective deadlock handling

Galen Boyer wrote:

> Yes it is much different. A deadlock should be akin to ORA-600.
> It is a bug in the application and should be fixed. In Oracle,
> you shouldn't code for deadlock detection (in SQLServer, you have
> to, cause it can happen at anytime). You should code so these
> don't happen. You should devise an exhaustive suite of tests to
> make sure deadlocks don't occur.

If you've done this post the code. I'll let my students have at it.

-- 
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)