Maybe this will help:
http://www.p6spy.com/________________________________
From: "De Stefano, Giovanni, VF-Group" <
[hidden email]>
To:
[hidden email]
Sent: Mon, November 2, 2009 4:16:34 PM
Subject: RE: Jackrabbit: how to log queries towards Oracle DB
Hello Thomas,
thanks a lot for the hint.
I will give it a shot and I will post my results here.
Cheers,
Giovanni
-----Original Message-----
From: Thomas Müller [mailto:
[hidden email]]
Sent: lunedì 2 novembre 2009 15.13
To:
[hidden email]
Subject: Re: Jackrabbit: how to log queries towards Oracle DB
Hi,
Jackrabbit calls almost the same JDBC methods no matter what database
backend is used. I don't know how to do that with Oracle, but you
could use another database that supports logging JDBC method calls,
for example the H2 database. You only need to append
;TRACE_LEVEL_FILE=3 or ;TRACE_LEVEL_SYSTEM_OUT=3 to the database URL.
See also:
http://www.h2database.com/html/features.html#trace_optionsI hope that helps.
Regards,
Thomas
On Mon, Nov 2, 2009 at 3:05 PM, De Stefano, Giovanni, VF-Group
<
[hidden email]> wrote:
> Hello all,
>
>
>
> I am new to Jackrabbit and I am struggling understanding if it is
> possible to log all possible transactions which are happening behind the
> curtains towards an Oracle database.
>
>
>
> Playing with log4j helped me a lot but I still need to see as much info
> as possible when it comes about Jackrabbit querying the DB.
>
>
>
> Is it possible?
>
>
>
> Any help is very well appreciated.
>
>
>
> Cheers,
>
> Giovanni
>
>
