Wrong update while cascading many-to-many relationship

Question

I have a many-to-many relationship defined on hibernate like this:

User

public class User{

private List<UserCustomer> userCustomerList;
    @OneToMany(fetch = FetchType.LAZY, mappedBy = "id.user", cascade=CascadeType.ALL)
    public List<UserCustomer> getUserCustomerList() {
        return userCustomerList;
    }
}

UserCustomer

@Entity
@Table(name = "RTDB_USER_CUSTOMER")
@Component("userCustomerEntity")
@AssociationOverrides({
    @AssociationOverride(name = "id.user", 
            joinColumns = @JoinColumn(name = "ID_USER")),
    @AssociationOverride(name = "id.customer", 
            joinColumns = @JoinColumn(name = "ID_CUSTOMER")) })

public class UserCustomer {

    @EmbeddedId
    public UserCustomerId getId() {
        return id;
    }

    @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumns({ @JoinColumn(name = "ID_ROLE_CUSTOMER", referencedColumnName = "ID") })           public RoleCustomer getRoleCustomer() {
        return roleCustomer;
    }

}

So a user has a list of UserCustomer, that represent roles of users over customers. The problem is, that when we change a role over a customer and call update(), instead of one row updated we get all the rows updated with the same role. When we call merge() it starts to perform a lots of queries and then gives stackoverflow exception ¿Could this be a mapping problem?

Is there a reason you have an entity for the join table (USER_CUSTOMER) ? It is not traditional in JPA to do so — Aviram Segal, Dec 06 '12 at 05:27
Yes, it is because the join table has additional attributes (roles). Is there any way of doing it without it? — Eugenio Cuevas, Dec 11 '12 at 14:39
ok i missed that, you got USERS, CUSTOMERS and USER_CUSTOMER which has user id, customer id and role ? — Aviram Segal, Dec 11 '12 at 14:42
did you see this? : http://stackoverflow.com/questions/5127129/mapping-many-to-many-association-table-with-extra-columns — Aviram Segal, Dec 11 '12 at 16:16

score 1 · Answer 1 · edited Dec 05 '12 at 12:46

1

Can you post the tables and updation code?

I think you are updating the role directly from UserCustomer which should be updating all the roles, as far as my understanding goes you do not want to update UserCustomer but only RoleCustomer. Try to fetch RoleCustomer and update it not the UserCustomer.

edited Dec 05 '12 at 12:46

durron597

31,968
17
99
158

answered Dec 05 '12 at 12:24

Divanshu

1,849
1
15
16

Wrong update while cascading many-to-many relationship

1 Answers1