I have problem getting p6spy to work with Tomcat 5.0 in windows XP.
Actually I have exatcly same problem than this post describes:
I really have spy.properties in my CLASSPATH, but anyway I receive error:
Unable to instantiate driver class com.p6spy.engine.spy.P6SpyDriver.
java.lang.InstantiationException: spy.properties not found in classpath at com.p6spy.engine.spy.P6SpyDriverCore.<init>(P6SpyDriverCore.java:331 at com.p6spy.engine.spy.P6SpyDriver.<init>(P6SpyDriver.java:82)
I've been trying to specify p6.home-setting, like installation guide tells:
but after Tomcat 4.0, settings is according to Tomcat documentation CATALINA_OPTS, not TOMCAT_OPTS like p6spy intallation says.
But when I specify CATALINA_OPTS environment variable, Tomcat does not even start anymore.
I really don't understand why Tomcat does not find properties file.
Where's the problem?
Thanks in advance!
Edson Carlos Ericksson Richter
Hi, guys. Take a long time since I tried to put P6Spy running with SQL Profiler under Tomcat. What I did? I did put p6spy and all other needed libraries (I don't remember what) under $TOMCAT_HOME/common/lib. I did put spy.properties on bin directory for Tomcat. The only problem I got that I could not use SQL Profiler whas P6Spy has no permission to start a network connection (through Log4J) when running under tomcat, and this forbidden loading the class - this gives the "error loading jdbc driver". Then I give it up, rewrote p6Spy to put everything on System.err without Log4J, and got my own solution.
I have been trying to start p6spy on tomcat 5.5 and on tomcat 6.0 and nothing. I get the message "spy.properties not found in classpath".
I have put the spy.properties in all of tomcat directories and nothing! :-(
I have configured the CLASSPATH environment variable and nothing! :-((
I have used the TOMCAT_OPS environment variable and nothing! :-(((
And I am about to throw in the towel but I would like to ask us this question:
Do anybody configure p6spy with tomcat 5.5 o superior and could send me a help for my problems?
Thank in advance.
we just use p6spy bundled with the war ... works fine.
Hi there -
Sorry for the late response. I think I am the only one who has recently done anything with p6spy. I got some basic access to this project from the only original developer I could reach. Unfortunately, not full project admin access. So I have moved over to github for further development.
You are welcome to help out there by forking and then sending me a pull request.
Further development at : https://github.com/patmoore/p6spy