Hello,

I've posted this issue already in German but maybe it is better to post it in English.

I have a constraint violation in my User-Right-Role example. When I delete a role that is associated to a user directly on my database, I get
SQL Error: 1451, SQLState: 23000
Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t_users_roles`, CONSTRAINT `FK_ur_roles_id` FOREIGN KEY (`roles_id`) REFERENCES `t_roles` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)

This is what I want to get.
But when I delete it via Hibernate, the role and all associations are deleted. Why?

I've posted the code already here:
viewtopic.php?f=10&t=1003113

Thanks in anticipation,
iiMaestro

Hibernate is smart enough to know (because you have mapped this in your code) that it needs to delete the entries in the association table before it can delete the role. Turn on SQL logging and you will see that Hibernate issues several delete statements to the association tables before the role is deleted. To solve this you can map the association as an inverse relation. It seems like you currently have both sides as non-inverse which is not recommended. Use the "mappedBy" attribute as shown in the documentation examples to map an inverse assocation. http://docs.jboss.org/hibernate/stable/ ... ollections (scroll down a bit to the Many-to-many section)

Thank you, nordborg.
You was right. When I insert the mappedBy clause everything works fine.

I used the Hibernate Tools for reverse engineering the mapping classes. That's why I did not use mappedBy. Maybe this comment can help also other newbies.

Thanks again.