Hello everyone. I have the following scenario:

ParentA, ChildB tables / classes

ParentA has:



The table ParentA has no reference to ChildB. ChildB has a foreign key on ParentA's primary key.

What I would like is that when I delete a ParentA, all of the ChildBs that reference it are also deleted.

I've tried to modify the above annotation by changing it to javax.persistence.CascadeType.ALL or adding orphanRemoval=true, but I still get the constraint violated exception.

What did I do wrong?

Thanks as always,
TD

You may need to look in you database for a FK constraint going from Parent to Child table and disable/remove it leaving only the FK constraint going from Child -> Parent.
I have experienced that when the database is created by hibernate one may experience that two foreign keys are created. One in each direction.

Thanks for the tip orwtech. I had the db already, and I checked that it only has one foreign key.
Now the issue is this:


This makes a delete of a ParentA work, deleting all the orphaned childrens in the process, as expected. The problem now is that making an update to ParentA (not related to its children) triggers this exception now: