Hi All,

I have classes called Role and User as below.
When I call user.removeRole(role); the role is removed from the Collection roles in user.
But the rows in the db are not updated, thus when I load user, it will still have the role that I have removed from its roles before.

public class Role ... {
...
Collection users = new TreeSet();
...

...
/**
* ...
*@hibernate.set
* table="USER_ROLE"
* lazy="true"
* cascade="save-update"
* @hibernate.collection-key
* column="ROLE_ID"
* @hibernate.collection-many-to-many
* class="User"
* column="USER_ID"
*/
public Collection getUsers() {
return users;
}
public void setUsers(Collection users) {
this.users = users;
}
...
}

public class User ... {
...
Collection roles = new TreeSet();
...

...
/**
* ...
*@hibernate.set
* table="USER_ROLE"
* inverse="true"
* lazy="true"
* cascade="save-update"
* @hibernate.collection-key
* column="USER_ID"
* @hibernate.collection-many-to-many
* class="Role"
* column="ROLE_ID"
*/
public Collection getRoles() {
return roles;
}
public void setRoles(Collection roles) {
this.roles = roles;
}
....
public void removeRole(Role role) {
role.getUsers().remove(this);
roles.remove(role);
}
}

I am using Hibernate 2.1 and MySQL Server 4.1.

I'd really appreciate if you can give me some advice on this. Thank you.

Best Regards,
Antonius Ng

cascade="save-update" should be cascade="all-delete-orphan"

Hi Pksiv,

Thanks for the reply.

I just want to deassociate the role from the user (removing it from the Collection attribute that user has), not deleting the role itself.
all-delete-orphan deletes the role..

Hi again,

This is what I have found out:

If I remove the role when the user object is transient, and after that I persist the user object and save it (session.saveOrUpdate(user)), the role will not be removed from the association table of USER_ROLE.

If I remove the role when the user object is persisted, the role is removed from the assocation table.

Strange thing is that if I add a role to the user when the user object is transient, and after that I persist the user object and save it, the new role will be added to the collection. This is not the case when I try to remove the role from the user....

So for the time being, I will persist the user object when removing a role from the user.

Thanks,
Antonius Ng