Remove the first entity and its relationship without removing the second entity - Spring Data JPA

Question

I have two entities, one of UserEntity and the other RoleEntity, the user can have multiple roles and the role can be used by multiple users, my entities look like:

@Entity
public class UsersEntity {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(nullable = false)
    private Long id;
    //...
    @ManyToMany(mappedBy = "users")
    private Set<RolesEntity> roles;
    //...

    // Getters and setters
}

@Entity
public class RolesEntity {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(nullable = false)
    private Integer id;
    @NotNull
    @Enumerated(EnumType.STRING)
    @Column(length = 20)
    private RoleEnum name;
    @JoinTable(name = "user_roles", joinColumns = {
        @JoinColumn(name = "role_id", referencedColumnName = "id", nullable = false)}, inverseJoinColumns = {
        @JoinColumn(name = "user_id", referencedColumnName = "id", nullable = false)})
    @ManyToMany
    private List<UsersEntity> users;
}

Generally roles are fixed they don't change a lot. Now I have a service:

public void removeUser(Long id) {
    if (userRepository.findById(id).isPresent()) {
        userRepository.deleteById(id);
    } else {
        throw new IllegalArgumentException("User not found!");
    }
}

My requirement is to remove only the user and not the roles related with this user, which mean remove the user and the relation ship. When I call the previews method I got.

org.postgresql.util.PSQLException: ERROR: update or delete on table "users" violates foreign key constraint "constraint_user_id" on table "user_roles"
  Detail: Key (id)=(4) is still referenced from table "user_roles".

Is there any trick to solve this please?

Antaaaa · Answer 1 · 2020-06-29T15:27:17.097

1

You need to make any references to that UsersEntity to be null.

So basically what is the problem? While RolesEntity has a reference to that UsersEntity class you cannot delete that. The most trivial thing to do is to make a loop for each RolesEntity in your UsersEntity class and remove everything from it.

Then you can successfully delete that user from your db.

Check this out to get more info: How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?

edited Jun 29 '20 at 15:27

answered Jun 29 '20 at 15:20

Antaaaa

233
3
14

1

Thank you, this help me, and I solved my issue as I mentioned in my answer. – Doesn't Matter Jun 29 '20 at 15:38

score 0 · Accepted Answer · answered Jun 29 '20 at 15:37

I solved my issue like this, I'm not sure if this is a best approach to solve this:

public void removeUser(Long id) {
    Optional<UsersEntity> userById = usersRepository.findById(id);
    if (userById.isPresent()) {
        UsersEntity user = userById.get();
        for (RolesEntity role : user.getRoles()) {
            role.setUsers(null);
            rolesRepository.save(role);
        }
        usersRepository.delete(user);
    } else {
        throw new IllegalArgumentException("User not found!");
    }
}

dassoop · Answer 3 · 2022-05-27T20:21:02.323

0

I think you can do this by using CascadeType.REMOVE

    @ManyToMany(cascade = CascadeType.REMOVE, fetch = FetchType.EAGER)
    @JoinTable(
            name = "users_roles",
            joinColumns = @JoinColumn(name = "user_id"),
            inverseJoinColumns = @JoinColumn(name = "role_id"))
    private List<Role> roles;

edited May 27 '22 at 20:21

answered May 27 '22 at 20:20

dassoop

11
2

It is better if you can added answer with clear code formatting (ex-: spaces, brackets) – Kaumadie Kariyawasam May 28 '22 at 01:59

Remove the first entity and its relationship without removing the second entity - Spring Data JPA

3 Answers3