A solution rather than a question for a change.
I had been able to get p6spy to run fine with OJB standalone and as usual, moving p6spy logging to a jBoss environment was not completely obvious. The instructions on the p6spy site were helpful but still left out some crucial details.
(http://www.p6spy.com/documentation/install.htm#jboss3)
What it comes down to is this:
Assuming you have a working JCA connection to your db using a
JBOSS_HOME\server\default\deploy\xxx-service.xml file, where xxx is your db,
1) simply make a copy of this file
2) rename if you want to p6spy-service.xml
3) replace the DriverClass setting to the p6spy driver:
<config-property name="DriverClass" type="java.lang.String">com.p6spy.engine.spy.P6SpyDriver</config-property>
4) remove the original xxx-service.xml so that there is not a conflict with your xxxDS JCA name
5) put the spy.properties file on the classpath: you may need to create a directory like
JBOSS_HOME\server\default\db\p6spy
and then modify JBOSS_HOME\bin\run.bat or .sh to include this directory on the classpath
6) spy.log will by dumped to the JBOSS_HOME\bin directory
hth,
Phil
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
