Hi, I'm new to Hibernate and I'm facing problem I can't find solution for.

I have two tables: price and discount and one association table - price_discount. Price and discount have many-to-many relation. Relation is defined in mapping classes like that:

in Price.java


in Discount.java


What I want is to be able to remove price or discount with all records in association table (and only them). When I delete price, everything works fine, but when I try to delete discount, hibernate throws an exception that discount is still referenced in price_discount table. How can I define this relation to enable removing associations from both directions?

Hi :)

You might try to remove all the prices from the discount before deleting it with something like



or, I'm not sure if you have to iterate over discount.getPrices() and say



-Kaj :)

Thanks for your answer. I was looking for the way to do this automatically and found out its rather impossible.

Price entity is kind of responsible for relationship and thats why associations are removed without problems. When removing discounts, I need to do this manually.