Auditing SQL queries

[Laurent Marchal]

Hello there,

   In our product we need to audit all the database modifications 
(creates, updates, deletes) and log them in an audit table. I see some 
olds posts in the ML about that and there are solutions for that in 
cayenne. But i would like to know if somebody have some hints about the 
best way to implement it with cayenne.

As we need to store the raw SQL query executed, should we use 
QueryLogger,  TransactionDelegate, DataContextDelegate, Lifycle listeners ?

Thanks.

Laurent