jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mihai Vasilache <mihai_vasila...@yahoo.com>
Subject Re: Jackrabbit: how to log queries towards Oracle DB
Date Mon, 02 Nov 2009 15:27:58 GMT

Maybe this will help: http://www.p6spy.com/





________________________________
From: "De Stefano, Giovanni, VF-Group" <Giovanni.DeStefano@vodafone.com>
To: users@jackrabbit.apache.org
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:thomas.mueller@day.com] 
Sent: lunedì 2 novembre 2009 15.13
To: users@jackrabbit.apache.org
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

<Giovanni.DeStefano@vodafone.com> 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

> 

> 
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message