Maybe this will help: http://www.p6spy.com/
________________________________ From: "De Stefano, Giovanni, VF-Group" <[email protected]> To: [email protected] 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:[email protected]] Sent: lunedì 2 novembre 2009 15.13 To: [email protected] 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_options I hope that helps. Regards, Thomas On Mon, Nov 2, 2009 at 3:05 PM, De Stefano, Giovanni, VF-Group <[email protected]> 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 > >
