Is it possible to use Hibernate (2.1.8) Auditable and Interceptors to populate audit information (date, user) to fields in the same table that maps to a given entity?

Say I have Customer which maps to the CUSTOMER table and want the fields LAST_MOD and LAST_MOD_USER to be populated. And I also have Order which maps to the ORDER table, and has the same fields.

I know I can insert records to a separate CUSTOMER_AUDIT table, but I want to update to the same table. Will this screw up the transaction or hibernate session?

Any examples on the web anyone can point me to?

There is an example of this on the Wiki (and I think in HIA).

I have _Hibernate in Action_ (the 2.x version) and the example there is for a separate table, not the same table as the entity. I'll search the wiki.

But actually in thinking about it some more, audit info in the same table doesn't make sense now to me anyway. You'd only be able to store the latest update info, losing the audit trail itself, and you wouldn't be able to retain audit info for deleted records....so perhaps that is why I didn't see an example of it earlier. It seems that storing info in a separate audit table is the way to go.

Thanks.

On the same row some times there are requirements to record when that row was last updated or first saved. Otherise history is needed in a separate table.

Hi,

I don't have HiA, can you direct me to the WIKI that you mention on how to do the audit trail for my reference?

Thank you.