Hello, I am using many-to-many mapping that are working great like this:


The problem is when one of this mappings have an intermediate table "User_Rules" that is not really a table, but a view.
The mapping works good when trying to retrieve elemnts of one table from the other.But when I try to delete an element from on of the tables (user for example), it tries to delete the element from the intermediate table ("User_Rules") as well, and it cant bacause in this case it is a view, and it gives me this error:



Is there a way to tell hibernate not to delete elements from the intermediate table?? thanks!!!

Isnt there a way to tell hibernate not to delete from the intermediate table in a many-to-many relation?
some thing like

on-delete="cascade",
or
cascade="none",
or
tell hibernate to see a table as a read only table so it never tries to delete an element from there...?

I dont know what else to try but it seems to me like something not so weird, is it?

if impossible... is at least possible to use a many to one relation, for example user to user_rules, and avoid deleting the reference in user_rules when deleting a user?

thanks.

I found a 2 years old post with the exact same problem, but no answers, which probably explains better the problem:
https://forums.hibernate.org/viewtopic.php?f=1&t=981204

I also have found a possible solution, which I havent been able to try yet. This would be to use the old delete way:

Some people was complaining that this method dont delete entries from join tables, and that is exactly what I need.