Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 68025 invoked from network); 9 Dec 2003 08:38:02 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 9 Dec 2003 08:38:02 -0000 Received: (qmail 83713 invoked by uid 500); 9 Dec 2003 08:37:36 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 83621 invoked by uid 500); 9 Dec 2003 08:37:35 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 83608 invoked from network); 9 Dec 2003 08:37:35 -0000 Received: from unknown (HELO msx.drei.com) (213.94.78.66) by daedalus.apache.org with SMTP; 9 Dec 2003 08:37:35 -0000 Received: from msx.drei.com ([10.249.20.17]) by msx.drei.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 9 Dec 2003 09:37:46 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: RE: How to add P6Spy: WAS: Printing SQL Date: Tue, 9 Dec 2003 09:37:46 +0100 Message-ID: <90B3A0967470D44CB8FDE74907512328F1B95C@av1s008.at-work.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How to add P6Spy: WAS: Printing SQL Thread-Index: AcO94RDt4vtA/NAmTwSqEZQZeRXBJgAToU3Q From: =?iso-8859-1?Q?=22G=F6schl=2CSiegfried=22?= To: "Apache Torque Users List" X-OriginalArrivalTime: 09 Dec 2003 08:37:46.0775 (UTC) FILETIME=[B8AF6A70:01C3BE2F] X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Done, don't know if I did everything correctly since this was my first = WIKI encounter ... :-) Cheers, Siegfried Goeschl -----Original Message----- From: Scott Eade [mailto:seade@backstagetech.com.au] Sent: Monday, December 08, 2003 11:21 PM To: Apache Torque Users List Subject: Re: How to add P6Spy: WAS: Printing SQL It would be good to add this information to the wiki. Scott --=20 Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au G=F6schl,Siegfried wrote: >Hi Sonu, > >some help for an entry level programmer with a console application - = life is harsh sometimes ... :-) > >+) add the p6spy.jar to your classpath >+) copy the spy.properties into your classpath (same location as = log4j.properties) >+) set the real driver in spy.properties, e.g. = realdriver=3Doracle.jdbc.driver.OracleDriver in my case >+) change the Torque.properties, e.g. = torque.dsfactory.XXX.connection.driver =3D = com.p6spy.engine.spy.P6SpyDriver > >The program creates a spy.log in your current directory ... piece of = cake looking at it ... ;-) > >Cheers, > >Siegfried Goeschl > =20 > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org