Re: How to handle deadlocks ?

Joachim Achtzehnter (joachim@softouch.bc.ca) wrote: : bgw@world.std.com (Bruce G Wilson) wrote: sybase seems to have more of a deadlock problem than Informix. I believe it is because they lack row-level locking. I've seen deadlocks occur even though the transactions are short and the locking order is the same. In sybase, these locks seem to be page 0 locks (whatever that is). My solution in all databases is to include retry code in either the error-handling routines or in-line, following attempts at updates. Check for 1205 error in Sybase...if you see 1205, retry the update. Informix has a couple of error codes (453 maybe?) that indicate deadlock conditions. Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) ---------------------------------------------------------------------------