How does JPA orphanRemoval=true differ from the ON DELETE CASCADE DML clause

hibernate jpa cascade cascading-deletes orphan-removal
Markos Fragkakis picture Markos Fragkakis · Dec 1, 2010 · Viewed 152.5k times · Source

I am a little confused about the JPA 2.0 orphanRemoval attribute.

I think I can see it is needed when I use my JPA provider's DB generation tools to create the underlying database DDL to have an ON DELETE CASCADE on the particular relation.

However, if the DB exists and it already has an ON DELETE CASCADE on the relation, is this not enough to cascade the deletion appropriately? What does the orphanRemoval do in addition?

Cheers

Answer

axtavt picture axtavt · Dec 1, 2010

orphanRemoval has nothing to do with ON DELETE CASCADE.

orphanRemoval is an entirely ORM-specific thing. It marks "child" entity to be removed when it's no longer referenced from the "parent" entity, e.g. when you remove the child entity from the corresponding collection of the parent entity.

ON DELETE CASCADE is a database-specific thing, it deletes the "child" row in the database when the "parent" row is deleted.

Related questions

JPA Hibernate many-to-many cascading

I am using JPA 2.0 and hibernate. I have a User class and a Group class as follows: public class User implements Serializable { @Id @Column(name="USER_ID") private String userId; @ManyToMany @JoinTable(name = "USER_GROUP", joinColumns = { @JoinColumn(name = "GROUP_ID") }, …

Read More
JPA + Hibernate: How to define a constraint having ON DELETE CASCADE

I am just wondering if there's such a way that I can have build my MySQL table as ALTER TABLE `USERINFO` ADD CONSTRAINT `FK_USER_ID` FOREIGN KEY (`USERID`) REFERENCES `USERACCOUNT` (`USERID`) ON DELETE CASCADE ON UPDATE CASCADE; However, I …

Read More
Hibernate Cascade PERSIST

I have a general question about Hibernate that I'm batteling with. I have class A and class B, where B is dependent on A In my code when I call em.persist(objOfTypeA) I would expect the insert to go …

Read More