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:[EMAIL PROTECTED] 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:
beforeHello. 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
I would be greatful. Thanks.
Charlie
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
