Hi All,
I am currently using Hibernate version 3.0 with Spring 1.2.5 for a web based application. I have a requirement, described below, for which I would like a solution using Hibernate if possible.
I need to use cascade logical delete(or cascade update) feature thats available in Hibernate. But before the cascade action needs to be executed, I need to get the information of all the entities that refer this instance upfront - their class type and if they are logically deleted or not - instead, an instance of all the entities referencing this instance would be adequate.
Based on the type of the referencing or associated entities I need to decide if the cascade update should be allowed or not.
Eg:- Company is associated with Address and User. I need to get all the instances of Address and User in case I need to logically delete Company. Only if the user instances are all already logically deleted, I can delete this Company instance but if there are only Address references, which are all active, then I can delete the Company as Address is not a very significant record in our application and can get logically deleted cascadingly. Supposing that Company can be allowed to be deleted, I will have to get the user(user of the application)'s confirmation before proceeding to do it.
Can I achieve this using Hibernate 3.0? If yes, then kindly give me pointers as to how this can be achieved. How can I retrieve the information even before a cascade is actually executed?
Any help is appreciated.

Regards and TIA,
Deepa

Enable bi-directional relation between company and user.

You can check