Re: Can I disable SELECT logging?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Mar 07 2008 - 12:50:20 EST

  • Next message: Borut Bolčina: "Remote Object Persistence Tutorial Setup"

    Seriously :-)

    The same logger definition is used to log all SQL, so there's no
    _direct_ way to selectively enable/disable parts of this. I guess
    another way is a custom Log4J appender that does grep internally.
    Which may not be a bad option - Log4J is infinitely customizable.

    Andrus

    On Mar 7, 2008, at 7:38 PM, Scott Anderson wrote:

    > How did I know someone was going to say that? :)
    >
    > -----Original Message-----
    > From: Andrus Adamchik [mailto:andru..bjectstyle.org]
    > Sent: Friday, March 07, 2008 2:52 AM
    > To: use..ayenne.apache.org
    > Subject: Re: Can I disable SELECT logging?
    >
    > Or just filter logs with 'grep'.
    >
    > Andrus
    >
    >
    > On Mar 7, 2008, at 12:36 AM, Aristedes Maniatis wrote:
    >
    >>
    >> On 07/03/2008, at 8:10 AM, Scott Anderson wrote:
    >>
    >>> Is there a way to tell Cayenne to log only INSERT, UPDATE, and
    >>> DELETE
    >
    >>> operations? In the production database, we have triggers that record
    >>> each row-level change in a shadow table, and I want to profile my
    >>> code to keep these operations to a minimum, but it's hard to do with
    >>> 90% of the console output displaying SELECT queries.
    >>
    >> If you are running Cayenne 3 you can use lifecycle events to do this.
    >>
    >> Ari Maniatis
    >>
    >>
    >>
    >> -------------------------->
    >> ish
    >> http://www.ish.com.au
    >> Level 1, 30 Wilson Street Newtown 2042 Australia
    >> phone +61 2 9550 5001 fax +61 2 9550 4001
    >> GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
    >>
    >>
    >>
    >
    >



    This archive was generated by hypermail 2.0.0 : Fri Mar 07 2008 - 12:50:55 EST