I have three tables: MENU, PERMISSION, and MENUPERMISSION. MENU contains menu options for a website, PERMISSION contains permissions users can possess, and MENUPERMISSION simply has columns MENUID and PERMISSIONID to represent the association of a certain permission with a certain menu option.

I want to create a many-to-many relationship in the PERMISSION hbm that will cascade delete to MENUPERMISSION but not MENU. That way when the admin user deletes a permission, all rows in MENUPERMISSION with the given PERMISSIONID will be deleted, but the associated MENU objects themselves will not be deleted. I've tried this:


I've tried it with cascade="delete", cascade="delete-orphan", and cascade="all,delete-orphan", and each time, all relevant objects from all three tables (including MENU) get deleted. What am I doing wrong?

Thanks,
Erica

I think I may have fixed it using cascade="none". It seems like that successfully deletes the associated MENUPERMISSION row when I delete a permission, without also deleting the MENU object the permission was previously associated with. Does that make sense?