DatabaseAudit

This is version 1. It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

Spring should help you do this pretty easily. You would setup a filter/manager at the service layer (extending/implementing the normal transaction manager) that inspects the request and inserts an audit record when appropriate. Then change your service config files to use that manager instead of the transaction manager.

Hibernate supports a flexible audit logging mechanism. Check out "Chapter 13 : Interceptors and events" in the Hibernate 3 Reference documentation or "Section 8.3.2 : Audit Logging" in Hibernate in Action for a detailed coverage on topic.

- The old style way of doing this is by using triggers and creating mirror audit tables for any tables you want to audit... this can be great if you have DBA's that will write this stuff for you!! (as you dont have to do anything!!)

- Oracle 9i now has auditing built in ...

- A crude (but quick) way is to log it to a special file (maybe setup via log4j or something), any modifications...

- There are some software that sits inbetween DAO and DB to log this stuff already..

http://www.p6spy.com/