Eclipse Community Forums: EclipseLink » foreign key constraint problem

Help

Home

Home » Eclipse Projects » EclipseLink » foreign key constraint problem(foreign key constraint problem)

Show: Today's Messages :: Show Polls :: Message Navigator

foreign key constraint problem [message #551315]

Thu, 05 August 2010 17:46

Steven Dahlin
Messages: 18
Registered: May 2010

Junior Member

With an application that is- for now run as a java app- I am attempting to commit an entity transactions with multiple tables and multiple inserts I am getting "ERROR: insert or update on table "<table>" violates foreign key constraint "<constraint_fk>". However, I set the process to stop after persisting the 2 tables involved so I could verify what is being put in place or at least what appears to be being put in place. The id used in the parent is the one being used by the child table for the column which has the foreign key constraint. Hence, I am frankly baffled.

Is there any way to monitor the actual sql statements such as inserts that are being executed against my postgresql db?

Thanks

Report message to a moderator

Re: foreign key constraint problem [message #551357 is a reply to message #551315]

Fri, 06 August 2010 02:27

Tom Eugelink
Messages: 801
Registered: July 2009

Senior Member

On 2010-08-05 23:46, Steven Dahlin wrote:
> With an application that is- for now run as a java app- I am attempting to commit an entity transactions with multiple tables and multiple inserts I am getting "ERROR: insert or update on table "<table>" violates foreign key constraint "<constraint_fk>". However, I set the process to stop after persisting the 2 tables involved so I could verify what is being put in place or at least what appears to be being put in place. The id used in the parent is the one being used by the child table for the column which has the foreign key constraint. Hence, I am frankly baffled.
>
> Is there any way to monitor the actual sql statements such as inserts that are being executed against my postgresql db?
>
> Thanks

You can enable logging in Eclipselink that displays in detail what SQL statements are being executed.
http://wiki.eclipse.org/EclipseLink/Examples/JPA/Logging

Report message to a moderator

Previous Topic:	javax.persistence.lock.timeout is beeing ignored...
Next Topic:	Java Architecture for XML Binding (JAXB) - Class not found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 04:03:14 EDT 2013