Database Audit Trail Solution for Spring

[dowchen]

Anyone has implemented any audit trail solution for Spring?

Could you give me some idea or even source code?

My wish is to have a audit trail interceptor catching the method names of the DAO and get the before and after image of the bean properties into a audit trail table.

Or any other idea is welcome too....let's discuss!

[toastchee]

Hi!

I just finished this a few minutes ago.

This is a good start:

http://www.onjava.com/lpt/a/4994

[dowchen]

I experienced problems when desiging the audit trail architecture using AOP, I hope someone can help, my design is:

An database audit trail interceptor with AutoProxyBeanName with monitoring the DAO on CRUD methods.

It is working fine, however, if I got a service (just like a session bean) doing a rollback, my interceptor does not know about the transaction, is there any way that my interceptor can know the service transaction so that no audit trail record is inserted when the service is rollback?!

I hope someone can really help me...I think many applications need such audit trail feature with using JDBC but not EJB/JDO implementation.

Thanks a lot! Any comments will be welcomed. :oops:

Dave

[davsclaus]

What about an AfterReturningAdvise?

I recon it still will have the problem of not being notified about the CMT rollback.