Ok, This doesn't make sense. Its pretty much standard.
I just have to ask if you're doing this entire sequence in a single connection? I mean you're not doing the insert in to table 1 in a different jdbc connection/thread, getting its results and then trying to use a different jdbc connection to insert in to the second table.? Are you using some form of connection pooling or just a straight single jdbc connection? > -----Original Message----- > From: Mikael Sundberg [mailto:[email protected]] > Sent: Thursday, February 19, 2009 7:32 AM > To: Derby Discussion; [email protected] > Subject: RE: Foreign keys cuases deadlock? > > Yes I belive that is the case. > The return code I get is the value of the "id" column of table1. This is > also the column that table2 has a foreign key to. > It fails before the Commit. More precise at the > prepearedStatement.executeUpdate for the second insert. > > If im unclear I can write a testcase for it. > /Micke > > -----Original Message----- > From: Michael Segel [mailto:[email protected]] On Behalf Of > [email protected] > Sent: den 19 februari 2009 14:21 > To: 'Derby Discussion' > Subject: RE: Foreign keys cuases deadlock? > > Let me see if I have this straight. > > Auto commit is off. > > You're trying the following pseudo code... > > Begin transaction > Insert into table 1 > Get some return code from the insert for your foreign key for table > 2 > Insert into table 2 > Commit Transaction > > And this is failing? > > > > -----Original Message----- > > From: Mikael Sundberg > [mailto:[email protected]] > > Sent: Thursday, February 19, 2009 7:08 AM > > To: Derby Discussion > > Subject: Foreign keys cuases deadlock? > > > > 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. > > > > /Micke >
