You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Gerhard Hipfinger <ge...@openforce.at> on 2004/02/20 00:22:12 UTC
Re: p6spy in webapp
hi charlie,
take a look at http://www.p6spy.com/
there you can get much more information about p6spy than on the ojb
site.
the properties file you mentioned is thy spy.properties. put it to your
classpath (i.e. WEB-INF/classes). you can get an example from the url
above. the file is documented very well, you should have no problems
whith.
gerhard
Am Fre, den 20.02.2004 schrieb Charles N. Harvey III um 00:32:
> Hello.
> I looked for this on mail-archive.com but could not find exactly what I
> was looking for. The FAQ on the site explains how to setup p6spy when
> running test cases. I want to run it in my webapp. Put the p6spy-1.3.jar
> in my WEB-INF/lib/ directory and set some settings in some properties
> file. Well, which properties file? I'm just uncertain of what to change
> and where.
>
> If someone can maybe send me a link to where this has been explained before
> I would be greatful. Thanks.
>
>
> Charlie
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: p6spy in webapp
Posted by "Charles N. Harvey III" <ch...@alloy.com>.
Thanks so much Cory.
This helped a great deal. Little tip though, use p6spy-1.1.jar and not
1.2 or
1.3. 1.2 and 1.3 log "resultset" and not just "result". "result" can be
turned off (like in 1.1) but "resultset" cannot. So it fills up your
log file
to an un-openable point with only a few queries. Especially if that
query returns
even a few hundred results.
Since you work three desks away from me I guess I should have just asked
you first
instead of the list. But maybe someone else benefited from our
conversation so
its not all bad.
Charlie
Cory L Hubert wrote:
> http://www.p6spy.com/documentation/install.htm#tomcat
>
> The properties file is the spy.properties file (a sample should be in your
>p6spy download). You can put that anywhere in the classpath. P6Spy will
>use the classloader to pick it up.
>
> In the spy.properties you'd specify your "real" JDBC driver (example Mysql
>or SQLServer driver).
>
> In OJB you'd edit your repository.xml and specify p6spy (not your
>realdriver) as your driver in your jdbc descriptor.
>
> So p6spy is just a wrapper around your real driver, it'll catch your OJB
>generated queries and print them out to where ever you told it too in your
>spy.properties file.
>
>
>-----Original Message-----
>From: Gerhard Hipfinger [mailto:gerhard.hipfinger@openforce.at]
>Sent: Thursday, February 19, 2004 6:22 PM
>To: OJB Users List
>Subject: Re: p6spy in webapp
>
>
>hi charlie,
>
>take a look at http://www.p6spy.com/
>
>there you can get much more information about p6spy than on the ojb
>site.
>
>the properties file you mentioned is thy spy.properties. put it to your
>classpath (i.e. WEB-INF/classes). you can get an example from the url
>above. the file is documented very well, you should have no problems
>whith.
>
>gerhard
>
>
>Am Fre, den 20.02.2004 schrieb Charles N. Harvey III um 00:32:
>
>
>>Hello.
>>I looked for this on mail-archive.com but could not find exactly what I
>>was looking for. The FAQ on the site explains how to setup p6spy when
>>running test cases. I want to run it in my webapp. Put the p6spy-1.3.jar
>>in my WEB-INF/lib/ directory and set some settings in some properties
>>file. Well, which properties file? I'm just uncertain of what to change
>>and where.
>>
>>If someone can maybe send me a link to where this has been explained
>>
>>
>before
>
>
>>I would be greatful. Thanks.
>>
>>
>>Charlie
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
RE: p6spy in webapp
Posted by Cory L Hubert <co...@ampagency.com>.
http://www.p6spy.com/documentation/install.htm#tomcat
The properties file is the spy.properties file (a sample should be in your
p6spy download). You can put that anywhere in the classpath. P6Spy will
use the classloader to pick it up.
In the spy.properties you'd specify your "real" JDBC driver (example Mysql
or SQLServer driver).
In OJB you'd edit your repository.xml and specify p6spy (not your
realdriver) as your driver in your jdbc descriptor.
So p6spy is just a wrapper around your real driver, it'll catch your OJB
generated queries and print them out to where ever you told it too in your
spy.properties file.
-----Original Message-----
From: Gerhard Hipfinger [mailto:gerhard.hipfinger@openforce.at]
Sent: Thursday, February 19, 2004 6:22 PM
To: OJB Users List
Subject: Re: p6spy in webapp
hi charlie,
take a look at http://www.p6spy.com/
there you can get much more information about p6spy than on the ojb
site.
the properties file you mentioned is thy spy.properties. put it to your
classpath (i.e. WEB-INF/classes). you can get an example from the url
above. the file is documented very well, you should have no problems
whith.
gerhard
Am Fre, den 20.02.2004 schrieb Charles N. Harvey III um 00:32:
> Hello.
> I looked for this on mail-archive.com but could not find exactly what I
> was looking for. The FAQ on the site explains how to setup p6spy when
> running test cases. I want to run it in my webapp. Put the p6spy-1.3.jar
> in my WEB-INF/lib/ directory and set some settings in some properties
> file. Well, which properties file? I'm just uncertain of what to change
> and where.
>
> If someone can maybe send me a link to where this has been explained
before
> I would be greatful. Thanks.
>
>
> Charlie
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org