Auditing SQL queries

From: Laurent Marchal (contac..enux.fr)
Date: Tue Feb 10 2009 - 18:05:24 EST

  • Next message: Mike Kienenberger: "Re: Auditing SQL queries"

    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

    This archive was generated by hypermail 2.0.0 : Tue Feb 10 2009 - 18:06:01 EST