Not connected to P6Spy despite good config

2009-01-17
2013-05-22
  • suhas walanjoo
    suhas walanjoo
    2009-01-17

    Hi,

    I made the following changes to my application:

    In spring-datasource.properties, I changed the driver class name as following
    #datasource.driverClassName=oracle.jdbc.driver.OracleDriver
    datasource.driverClassName=com.p6spy.engine.spy.P6SpyDriver

    Used given spy.properties from p6spy distribution and changed as following:

    Added
    # oracle driver
    realdriver=oracle.jdbc.driver.OracleDriver
    Commented
    # the mysql open source driver
    #realdriver2=org.gjt.mm.mysql.Driver

    Put it in a diectory so that it would be picked up by maven during the build and it would be puts  in WEB-INF/classes directory

    next I changed pom.xml of my application to add

    <dependency>
    <groupId>p6spy</groupId>
    <artifactId>p6spy</artifactId>
    <version>1.3</version>
    </dependency>
    I used "jar -tvf mywebapp.war" command  to check both the above files exist in the respective directories of WEB-INF.

    I started Jahia SQL profiler with this command
    java -Xmx256m -jar sqlprofiler.jar

    and then only deployed the application war on weblogic. The modified application seems to work as usual.
      
    However, Jahia SQL Profiler does give an error message "Not Connected to P6Spy"

    Please help.

    Regards,

    Suhaas