Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hit deadlock with 2 threads updating DIFFERENT tables! Why?

Re: Hit deadlock with 2 threads updating DIFFERENT tables! Why?

From: theRat <john_hilgedick_at_yahoo.com>
Date: 11 May 2006 15:06:09 -0700
Message-ID: <1147385169.904709.211720@y43g2000cwc.googlegroups.com> 





Well, you are correct about the constraint between the 2 tables.  The
Task table has a column called managerId which is a foreign key into
the Managers table.  So, again, one thread is trying to update the
managerId in the Task table and the other thread is trying to get a
pessimistic lock on the Manager table.  It is probably true that both
threads are working with the same "manager".



Can you explain why this would matter?
Received on Thu May 11 2006 - 17:06:09 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US