Hi,

i've got a question about a many-to-many relation.

I mapped a Person to an institute. So one Person can work in many institutes and in one institute works a lot of people.

The Hibernate creates 3 tables. One for the persons, one fpr the institutes and on for the relation. Now my problem:

When I delete an institute. I also want to delete the relation in the table. I set the parameter cascade="all-delete-orphan" but I still got an exception:

"org.hibernate.exception.ConstraintViolationException: could not delete: "

Maybe one of you can help me?

Hi,

For many-to-many association you don't need to set any cascade style for deleting only if you want to save/persist the related entity, but I guess is not your case.
When you delete an Institute the relations will be deleted automatically even if you don't have any cascade style set.

The error appear now because you want to delete an Institute and also the Person's entities that are associated with that Institute, that is the effect of using cascade style, and I am sure that you have some of those Person's entities that are related also with other Institute.

I hope this help.
Calin.