How to implement an Audit Interceptor using iBATIS ?

Question

I want to log all changes in my database for auditing purposes, using a table called AuditEvent that stores the modified row ID (primary key), table name, column name, previous value, new value, date of change (timestamp), operation type (insert / update / delete) and the name of the user who did the changes.

I'm using SQL Server 2005, but I don't want to use triggers, because since I use a connection pool it would be difficult to find the current user.

The Hibernate solution based on an Interceptor is pretty simple. How do I do something similar when using iBATIS / iBATOR ?

Answer 1

If you're using spring, you might be able to use SqlMapClientDaoSupport to write template Dao objects that wrap auditing up with whatever transaction support you are using. If not, there is an iBatis Doa template option, iBatis DAO. That has been depreciated so you might be better off with Spring.