How to cascade delete ManyToMany

pyorg · **Joined:** Wed Nov 29, 2006 11:38 am **Posts:** 5

Hello,

I've got the code bellow with two many to many associations.

Code:

@ManyToMany(cascade = {CascadeType.ALL} , fetch=FetchType.LAZY)
@JoinTable(name = "T1", joinColumns = @JoinColumn(name = "C1"), inverseJoinColumns = @JoinColumn(name = "C2"))
private List<AuthorizationUnit> authorizationUnits;

@ManyToMany(cascade = {CascadeType.ALL} , fetch = FetchType.LAZY)
@JoinTable(name = "T2", joinColumns = @JoinColumn(name = "C3"), inverseJoinColumns = @JoinColumn(name = "C4")) 
private List<Attachment> attachments;

For the first association I would like to cascade delete only the association (in the table T1). It is the current behavior.
For the second association I would like to cascade delete the association and the entity (Attachment).

Thanks for your help,
Pierre-Yves

emmanuel · **Posted:** Fri Jan 12, 2007 8:12 pm

you mean a delete orphan semantic for many to many? It does not make sense

pyorg · **Joined:** Wed Nov 29, 2006 11:38 am **Posts:** 5

You're totaly right.
I should have a oneToMany relationship between my class and the Attachment entity.

Code:

@ManyToMany(cascade = {CascadeType.ALL} , fetch = FetchType.LAZY)
@JoinTable(name = "T2", joinColumns = @JoinColumn(name = "C3"), inverseJoinColumns = @JoinColumn(name = "C4")) 
@Cascade(org.hibernate.annotations.CascadeType.DELETE_ORPHAN)

is also working...

Py