Hi!
I have two tables (Table A and B) with a many to many relationship and an intermediate table (Table C).

The problem is that when I take a reference of table A and call it's delete method, it deletes data from Table C and Table A, but not from Table B.

Can anyone tell me a way to delete data from Table B also, if the data doesn't have any entry in the Table C.

My mapping files has the following description.
TableA.hbm.xml contains cascade="save-update"

TableB.hbm.xml contains inverse="true" cascade="save-update"

thanks

You can use the delete-orphan value for the cascade attribute.

I think you should follow the recommendation of Hibernate authors to not use many-to-many relationships by mapping the relationship table.

Hi!

The problem is that, if I use cascade="save-update,delete-orphan" or "all-delete-orphan", then the data relating to other values is also deleted. e.g.

Table A: has id's 1 and 2
Table B has id's 3 and 4
and Table C (Intermediate table) has id's, one from Table A and other from Table B
1 --- 3
1 --- 4
2 --- 4

On using "all-delete-orphane" option, both the enteries from Table A, B, C are deleted, as 4 is linked with both values of Table A.

Recommendation from "Hibernate authors to not use many-to-many relationships by mapping the relationship table" is applicable if we have any additional columns in the link table, but I don't have any additional column. If I am wrong in understanding this recommendation, kindly correct me.

Waiting for reponse.

thanks

The recommendation of not using many-to-many relationships is, as far as I understand, in prevision of future changes. So, they recommend their usage even if you do not have more columns.

As for the "delete-orphan" option, I understood that this was the behavior you wanted: