no spy.log for JBoss 4 and Hibernate

Help
andrewdc
2010-07-28
2013-04-25
  • andrewdc
    andrewdc
    2010-07-28

    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&amp;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.

     
  • Pat
    Pat
    2010-12-28

    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!