Re: Transaction foreign key violation - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Transaction foreign key violation
Date
Msg-id 445A2D4F.9070403@opencloud.com
Whole thread Raw
In response to Transaction foreign key violation  (Martina <boehme@mpiib-berlin.mpg.de>)
List pgsql-jdbc
Martina wrote:
>
> I'm getting a foreign key constraint violation if I run a transaction in
> which the first statement inserts a new row in Table1 (with serial as
> pk, "idTable1") and the second statement gets this "idTable1" as a fk.
> Because it is not there yet (but in the same transaction) I get this
> error. If I don't use transaction it is working.
> What can I do?

Can you show us your code, or (better) a small testcase that shows the
problem?

> I tried "SET
> TRANSACTION ISOLATION LEVEL SERIALIZABLE" (just with query.execute()
> before the other statements)) - no luck.

The right way to do this is via Connection.setTransactionIsolation().

-O

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Bug with callable statement and output parameters
Next
From: diego@adminsa.com
Date:
Subject: rowInserted, rowDeleted and rowUpdated