db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mikael Sundberg" <Mikael.Sundb...@artificial-solutions.com>
Subject Foreign keys cuases deadlock?
Date Thu, 19 Feb 2009 13:07:43 GMT
Hi I have the following problem.

Im using autocommit off.
I start by inserting into table1.

I then want to insert into table2 that has a foreign key to table 1. (I
use generatedkeys from my insert)
This fails since it cant obtaing a lock on table1
Is that expected?
If I add a commit between the two statements it works.


View raw message