Hey,
I will ask for 2 use cases:
1. user has list of shipping address + list of hotel address and etc.
now one of the shipping address has been changed. if you implement audit by hibernate interceptor of db triggers you dont have the context of the change. you dont know to say that one of the user shipping address has been changed. you just know that address street change from X to Y. any ideas?
2. many entities (from type Y) have reference to entiy X. now instance X-1 which is referenced by Y-1,Y-2,Y-3 is changed. The audit need to be registerd as a change for Y-1,Y-2,Y-3. do you have cases like this in your application? how you create the context? (one way will be to have a query for X taht will find all Y that depend on it, but somtimes it more than one join).
Thank you
