Remove OneToMany / ManyToOne

Bonjour,

J'ai deux entités :

Users :

Code:

---

1 2 3

@OneToMany(mappedBy = "users", cascade = CascadeType.ALL, orphanRemoval = true) private List<Authorities> authoritiesList;

---

Authorities :

Code:

---

1 2 3

@JoinColumn(name = "username", referencedColumnName = "username", insertable = false, updatable = false) @ManyToOne private Users users;

---

DAO :

Code:

---

1 2 3

getEM().getTransaction().begin(); getEM().remove(pUser); getEM().getTransaction().commit();

---

Message d'erreur :

Cannot delete or update a parent row: a foreign key constraint fails (`*****`.`authorities`, CONSTRAINT `****` FOREIGN KEY (`username`) REFERENCES `users` (`username`))

Je ne trouve pas la solution :( j'ai bien essayer de supprimer les authorities de l'utilisateur avant, de mettre à null l'user sur les authorities...

Merci de votre aide

salut,
tu dois d´abord supprimer toutes les references a

Code:

---

List<Authorities> authoritiesList

---

avant de pouvoir supprimer pUsers.

Eric

Voici la solution

Code:

---

1 2 3 4 5 6 7 8 9 10 11

if (pUser.getAuthoritiesList() != null) { getEM().getTransaction().begin(); List<Authorities> authoritieses = pUser.getAuthoritiesList(); for (Authorities a : authoritieses) { a.setUsers(null); getEM().remove(a); } pUser.getAuthoritiesList().clear(); pUser = getEM().merge(pUser); getEM().getTransaction().commit(); }

---