title: Implementing Audit Trail- Spring AOP vs.Hibernate Interceptor vs DB Trigger
body: <p>I found couple of discussion threads on this- but nothing which brought a comparison of all three mechanism under one thread.</p>
  
  <p>So here is my question...</p>
  
  <p>I need to audit DB changes- insert\updates\deletes to business objects.</p>
  
  <p>I can think of three ways to do this</p>
  
  <p>1) DB Triggers</p>
  
  <p>2) Hibernate interceptors</p>
  
  <p>3) Spring AOP</p>
  
  <p>(This question is specific to a Spring\Hibernate\RDBMS- I guess this is neutral to java\c# or hibernate\nhibernate- but if your answer is dependent upon C++ or Java or specific implementation of hibernate- please specify)</p>
  
  <p>What are the pros and cons of selecting one of these strategies ?</p>
  
  <p>I am not asking for implementation details.-This is a design discussion. </p>
  
  <p>I am hoping we can make this as a part of community wiki </p>