Below is my mysql-ds.xml:
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/so?uniCode=true&characterEncoding=UTF-8</connection-url>
<driver-class>com.p6spy.engine.spy.P6SpyDriver</driver-class>
<user-name>root</user-name>
<password></password>
</local-tx-datasource>
</datasources>
My spy.properties only has one change:
# mysql Connector/J driver
realdriver=com.mysql.jdbc.Driver
After I restarted JBoss after dropping p6spy.jar in <JBoss-Server-Dir>/lib, and run some queries through Hibernate,
I wasn't able to find spy.log anywhere even I searched my entire harddrive. I have also tried changing to use appender=com.p6spy.engine.logging.appender.StdoutLogger, but nothing was written to console either.
Any hint or tip is appreciated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I am new to p6spy and I am trying to get it to work under JBoss 4 and Hibernate. I was following the documentation for "JBoss 3.x" in
http://www.p6spy.com/documentation/install.htm.
Below is my mysql-ds.xml:
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/so?uniCode=true&characterEncoding=UTF-8</connection-url>
<driver-class>com.p6spy.engine.spy.P6SpyDriver</driver-class>
<user-name>root</user-name>
<password></password>
</local-tx-datasource>
</datasources>
My spy.properties only has one change:
# mysql Connector/J driver
realdriver=com.mysql.jdbc.Driver
After I restarted JBoss after dropping p6spy.jar in <JBoss-Server-Dir>/lib, and run some queries through Hibernate,
I wasn't able to find spy.log anywhere even I searched my entire harddrive. I have also tried changing to use appender=com.p6spy.engine.logging.appender.StdoutLogger, but nothing was written to console either.
Any hint or tip is appreciated.
sorry … forgot to set my monitoring on this…
The code is ow over on github if you figured out your problem and have a patch would appreciate the fork + pull request!
https://github.com/patmoore/p6spy