Hi,

Using Hibernate 3 and trying to build some automatic change-auditing code to add into the persistence layer. What I'd like to do is have a table that logs the old and new value of each field when it's updated and saved to the database.

I've started off by using the example in Chapter 8 of Hibernate in Action which uses an Interceptor class to build a "change list" and then after the session has been flushed, saves the details of the changes to the audit tables.

Would you recommend using the Interceptor for this, or would the Event Listener mechanism be more appropriate for this task?

Any pointers to example code for doing this sort of this would be really appreciated.

Thanks,
David.

Currently, I'd recommend the Interceptor approach.

The reasoning is that the Listeners are really mis-named; they are actually event-handlers or event-processors. So if you go the Listener approach, your class is basically responsible for processing the generated event in-total. Of course you can just extend the appropriate default Listener, but then you'd have to know which protected methods to tie into in order to get at the needed state, etc. Hopefully this will all be simplified at some stage.

For Hibernate 3.1?

http://www.hibernate.org/318.html
http://forum.hibernate.org/viewtopic.ph ... r&start=30

We're trying to find the best audit interceptor solution to use for a new application. thx