Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Hit deadlock with 2 threads updating DIFFERENT tables! Why?
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