Charles Anthony wrote:
Just a note on p6spy which may, or may not, be relevant : I've often had
problems with processes finding the p6spy.properties file - it always seems
to work for me if the file is in the "current" directory when the process
starts.
So, for tomcat, for example, it seems to read the file from
jakarta-tomcat-blah\bin
It *doesn't* seem to be read from the classpath.
This is not definitive, just something I recall from the dusty dank archives
of my brain. Please treat with the appropriate amount of disdain.
Another catch-all failure of getting P6Spy to work under Tomcat is if
a servlet with load-on-startup=1 registers the standard JDBC driver
before the application/servlet with P6 is loaded.
In this scenario one has to make sure that spy.properties is in
CATALINA_HOME/common/classes and that p6spy.jar is in
CATALINA_HOME/common/lib (as opposed to WEB-INF/classes and
WEB-INF/lib respectively).
Then it's also important to have the deregister directive in spy.properties
set to "true" so that P6 first de-registers the already loaded JDBC driver
from DriverManager before registering it's own one.
I guess these pieces of info should be a good start for a FAQ entry some day. ;)
Cheers,
Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
