BatchUpdateException when removing a entity with a ManyToMan

[icordoba]

Hi there,
I am getting BatchUpdateException when removing entities related to others by a ManyToMany association. Hibernate creates the link table with foreign keys and they make that BatchUpdateException to be thrown (I like tables to have foreign keys, of course).
I've tried to add a REMOVE cascade, but that makes the end entity to be also removed (for example, removing a UserRole entity removes related User, while only should remove the entry in the intermediate link table.
My question is... do I have to remove that relation in target entities before removing the related entity or there is a way to make JBoss/Hibernate to do some intermediate table cascading to remove the relation and avoiding BatchUpdateException?

Thanks for any idea,
Ignacio

[itsme]

HI,

to get this piece of work done, get to your User, remove the Role, merge the User and then finally delete the Role.

Hope this helps.
\sandor\

[icordoba]

In my case some of the entities have 2 o 3 ManyToMany each so it is tedious not to have a direct way to solve this.
Thanks a lot for your reply.
Ignacio