Auditing in Spring-Hibernate - Separate Audit table for each table

Hi all,

I have searched the net but cannot able to find the solution to my problem.
We need to have separate audit table for each table in DB. the audit table have few more fields and have same parent-child relation as defined in the main table.
Envers is not an option for us, so please ignore this for solution.

Now if use interceptors, all the audit data should go into one table, which is not the solution.

urgent help required.

Amit

For the purpose of auditing, you want to know what is happending to your system in whole. In the other words, your approach is not designed for the goal. You need to rethink your audition design. And for the audition purpose, you don't need to maintain any data relationship constraint.