Hi,

I've a table which holds the primary key(ACL_TABLE) of 5 other tables in one column. The 5 other tables don't have any foreign-key contraint with the ACL_TABLE table. Now, whenever a record in the 5 other tables is deleted, I want the corresponding record in this table deleted as well.

However, my application does not know when the 5 other table records are deleted. So, I can't delete the record in this table. I can't use CASCADE.DELETE as they are not bound by any relatiship.

I'm thinking of using Hibernate interceptor where onDelete of the record, I'll go and delete the record in the ACL_TABLE. However, after investigation, I found that you can't do this with interceptor as interceptor only allows you to work on the entity that is being deleted.

Is there any way I can solve this problem. I don't want to use Trigger(like Oracle trigger) as I would like to do this in the application.

Any suggestions will be appreciated.

thanks
-ron

Why not? Why can't you run a delete query inside the onDelete() method?

Why don't you use triggers? Doesn't your db support them!?

--No, I can delete it in onDelete only if I create a new temporary session.

--I don't want to use db triggers because the app I'm building is supposed to work with many databases and so most of the stuffs should be done within application