Spring Boot JPA many to many delete cascade

Question

So i have a MyUser entity which refers to a Role entity with a many to many relationship. But when i try to delete the user, i always get the errror that the user_id is always referenced on the user_role jointable...

I have already tried every cascade type... but didn't get the solution Please help Thanks

@Table(name = "users") public class MyUser { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; ... Other properties ... @ManyToMany @JoinTable( name = "users_roles", joinColumns = @JoinColumn( name = "user_id", referencedColumnName = "id"), inverseJoinColumns = @JoinColumn( name = "role_id", referencedColumnName = "id")) private Collection<Role> roles; // getters setters } @Entity @Table(name = "roles") public class Role { @Id @GeneratedValue(strategy = GenerationType.AUTO) private Integer id; private String role; // getters setters }

maybe this helps: stackoverflow.com/questions/306144/…

Jens
– Jens

2020-12-18 10:43:00 +00:00
Commented Dec 18, 2020 at 10:43 — Jens
– Jens, Commented Dec 18, 2020 at 10:43

SternK · Accepted Answer · 2020-12-18 13:20:18Z

As it stated in the documentation:

For @ManyToMany associations, the REMOVE entity state transition doesn’t make sense to be cascaded because it will propagate beyond the link table. Since the other side might be referenced by other entities on the parent-side, the automatic removal might end up in a ConstraintViolationException.

So, before removing Role entity you should be assured that there is no MyUser entity linked with this role.

Collectives™ on Stack Overflow

Spring Boot JPA many to many delete cascade

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related