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

[Message index]

		foreign key constraint problem By: Steven Dahlin on Thu, 05 August 2010 17:46
		Re: foreign key constraint problem By: Tom Eugelink on Fri, 06 August 2010 02:27

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 20:49:47 EDT 2013