[OS-JIRA] Created: (CAY-414) Support for (batch) query interception and audit

From: jira-norepl..bjectstyle.org
Date: Sat Dec 31 2005 - 02:02:45 EST

  • Next message: Mike Kienenberger: "Re: No access to getObjectStore().getFlattenedInserts() / getFlattenedDeletes()"

    Message:

      A new issue has been created in JIRA.

    ---------------------------------------------------------------------
    View the issue:

      http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-414

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-414
        Summary: Support for (batch) query interception and audit
           Type: Improvement

         Status: Assigned
       Priority: Major

        Project: Cayenne
     Components:
                 Cayenne Core Library
       Versions:
                 1.2 [DEV]

       Assignee: Andrus Adamchik
       Reporter: Andrus Adamchik

        Created: Sat, 31 Dec 2005 2:02 AM
        Updated: Sat, 31 Dec 2005 2:02 AM

    Description:
    There is a common need to audit what Cayenne saves to the database. Currently people implement custom solutions, usually based on inspecting ObjectStore or overriding validateFor* on DataObjects. Due to a mismatch between object model and DB schema (after all ORM is intended to hide many DB details, think flattened relationships and such), clean audit is not always possible to be done that way.

    Ideally the solution should be intercepting BatchQueries, as this is what is being sent to the database in its raw form. Audit log should be commitable to the DB (two scenarios were mentioned: log committed in the same or in a separate transaction from the main change).

    The discussion of the possible design started in this thread:

    http://objectstyle.org/cayenne/lists/cayenne-devel/2005/12/0087.html

    Not sure if we should implement a standard "cayenne audit" feature, or simply provide needed extension points and post an audit solution as an example. I am more in favor of a second option (simple extension point) as the actual audit requirements may vary from app to app.

    ---------------------------------------------------------------------
    JIRA INFORMATION:
    This message is automatically generated by JIRA.

    If you think it was sent incorrectly contact one of the administrators:
       http://objectstyle.org/jira/secure/Administrators.jspa

    If you want more information on JIRA, or have a bug to report see:
       http://www.atlassian.com/software/jira

    This archive was generated by hypermail 2.0.0 : Sat Dec 31 2005 - 02:02:47 EST