WAS 4.0.2 configuration with p6spy

Aroni
2004-07-13
2004-07-13
  • Aroni
    Aroni
    2004-07-13

    I am getting the following error with was trying to connect to db2. Can someone please help?
    Caused By: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver: com.p6spy.engine.spy.P6DriverNotFoundError: Error registering driver  [org.gjt.mm.mysql.Driver]
    Caused By: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
        at com.p6spy.engine.spy.P6SpyDriverCore.initMethod(P6SpyDriverCore.java:289)
        at com.p6spy.engine.spy.P6SpyDriver.initMethod(P6SpyDriver.java:78)
        at com.p6spy.engine.spy.P6SpyDriver.<clinit>(P6SpyDriver.java:74)
        at java.lang.Class.forName1(Native Method)
        at java.lang.Class.forName(Class.java:134)
        at com.p6spy.engine.spy.P6DataSource.class$(P6DataSource.java:123)
        at com.p6spy.engine.spy.P6DataSource.initMethod(P6DataSource.java:123)
        at com.p6spy.engine.spy.P6DataSource.<clinit>(P6DataSource.java:119)
        at java.lang.Class.newInstance0(Native Method)
        at java.lang.Class.newInstance(Class.java:254)
        at com.ibm.ejs.cm.DataSourceProperties.instantiateObject(DataSourceProperties.java:273)
        at com.ibm.ejs.cm.DataSourceProperties.getGenericDataSource(DataSourceProperties.java:155)
        at com.ibm.ejs.cm.DataSourceProperties.getConnectionPoolDataSource(DataSourceProperties.java:95)
        at com.ibm.ejs.cm.portability.PortabilityLayerImpl.getDataSource(PortabilityLayerImpl.java:655)
        at com.ibm.ejs.cm.JDBC1PhaseRF.createConnectionFactory(JDBC1PhaseRF.java:56)
        at com.ibm.ejs.cm.DataSourceImpl$3.run(DataSourceImpl.java:197)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.ibm.ejs.cm.DataSourceImpl.getSource(DataSourceImpl.java:195)
        at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:122)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:120)
        at com.apl.tas.util.DataConnection.getConnection(DataConnection.java:58)
        at com.apl.tas.data.security.TASSecurity.getLocations(TASSecurity.java:312)
        at com.apl.tas.action.TASLoginServlet.doPost(TASLoginServlet.java:119)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
        at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
        at com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecycleServlet.java:317)
        at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
        at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
        at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
        at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:523)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:282)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:112)
        at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:91)
        at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:184)
        at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
        at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:122)
        at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)
        at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
        at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:323)
        at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)
        at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)

    [7/12/04 20:37:45:206 PDT] 191b2b86 SystemOut     U Time to read ds, jdbc/Realjdbc/P6DB2 = 0
    [7/12/04 20:37:45:206 PDT] 191b2b86 WebGroup      X Servlet Error: com/p6spy/engine/spy/P6ConnectionPoolDataSource: java.lang.NoClassDefFoundError: com/p6spy/engine/spy/P6ConnectionPoolDataSource
        at java.lang.Class.newInstance0(Native Method)
        at java.lang.Class.newInstance(Class.java:254)
        at com.ibm.ejs.cm.DataSourceProperties.instantiateObject(DataSourceProperties.java:273)
        at com.ibm.ejs.cm.DataSourceProperties.getGenericDataSource(DataSourceProperties.java:155)
        at com.ibm.ejs.cm.DataSourceProperties.getConnectionPoolDataSource(DataSourceProperties.java:95)
        at com.ibm.ejs.cm.portability.PortabilityLayerImpl.getDataSource(PortabilityLayerImpl.java:655)
        at com.ibm.ejs.cm.JDBC1PhaseRF.createConnectionFactory(JDBC1PhaseRF.java:56)
        at com.ibm.ejs.cm.DataSourceImpl$3.run(DataSourceImpl.java:197)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.ibm.ejs.cm.DataSourceImpl.getSource(DataSourceImpl.java:195)
        at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:122)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:120)
        at com.apl.tas.util.DataConnection.getConnection(DataConnection.java:58)
        at com.apl.tas.data.security.TASSecurity.getLocations(TASSecurity.java:312)
        at com.apl.tas.action.TASLoginServlet.doPost(TASLoginServlet.java:119)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
        at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
        at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
        at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
        at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
        at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
        at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:523)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:282)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:112)
        at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:91)
        at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:184)
        at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
        at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:122)
        at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)
        at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
        at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:323)
        at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)
        at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)[7/12/04 20:37:44:515 PDT] 191ceb86 WebGroup      X Servlet Error: Error registering driver  [org.gjt.mm.mysql.Driver]
    Caused By: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver: com.p6spy.engine.spy.P6DriverNotFoundError: Error registering driver  [org.gjt.mm.mysql.Driver]
    Caused By: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
        at com.p6spy.engine.spy.P6SpyDriverCore.initMethod(P6SpyDriverCore.java:289)
        at com.p6spy.engine.spy.P6SpyDriver.initMethod(P6SpyDriver.java:78)
        at com.p6spy.engine.spy.P6SpyDriver.<clinit>(P6SpyDriver.java:74)
        at java.lang.Class.forName1(Native Method)
        at java.lang.Class.forName(Class.java:134)
        at com.p6spy.engine.spy.P6DataSource.class$(P6DataSource.java:123)
        at com.p6spy.engine.spy.P6DataSource.initMethod(P6DataSource.java:123)
        at com.p6spy.engine.spy.P6DataSource.<clinit>(P6DataSource.java:119)
        at java.lang.Class.newInstance0(Native Method)
        at java.lang.Class.newInstance(Class.java:254)
        at com.ibm.ejs.cm.DataSourceProperties.instantiateObject(DataSourceProperties.java:273)
        at com.ibm.ejs.cm.DataSourceProperties.getGenericDataSource(DataSourceProperties.java:155)
        at com.ibm.ejs.cm.DataSourceProperties.getConnectionPoolDataSource(DataSourceProperties.java:95)
        at com.ibm.ejs.cm.portability.PortabilityLayerImpl.getDataSource(PortabilityLayerImpl.java:655)
        at com.ibm.ejs.cm.JDBC1PhaseRF.createConnectionFactory(JDBC1PhaseRF.java:56)
        at com.ibm.ejs.cm.DataSourceImpl$3.run(DataSourceImpl.java:197)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.ibm.ejs.cm.DataSourceImpl.getSource(DataSourceImpl.java:195)
        at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:122)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:120)
        at com.apl.tas.util.DataConnection.getConnection(DataConnection.java:58)
        at com.apl.tas.data.security.TASSecurity.getLocations(TASSecurity.java:312)
        at com.apl.tas.action.TASLoginServlet.doPost(TASLoginServlet.java:119)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
        at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
        at com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecycleServlet.java:317)
        at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
        at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
        at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
        at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:523)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:282)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:112)
        at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:91)
        at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:184)
        at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
        at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:122)
        at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)
        at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
        at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:323)
        at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)
        at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)

    [7/12/04 20:37:45:206 PDT] 191b2b86 SystemOut     U Time to read ds, jdbc/Realjdbc/P6DB2 = 0
    [7/12/04 20:37:45:206 PDT] 191b2b86 WebGroup      X Servlet Error: com/p6spy/engine/spy/P6ConnectionPoolDataSource: java.lang.NoClassDefFoundError: com/p6spy/engine/spy/P6ConnectionPoolDataSource
        at java.lang.Class.newInstance0(Native Method)
        at java.lang.Class.newInstance(Class.java:254)
        at com.ibm.ejs.cm.DataSourceProperties.instantiateObject(DataSourceProperties.java:273)
        at com.ibm.ejs.cm.DataSourceProperties.getGenericDataSource(DataSourceProperties.java:155)
        at com.ibm.ejs.cm.DataSourceProperties.getConnectionPoolDataSource(DataSourceProperties.java:95)
        at com.ibm.ejs.cm.portability.PortabilityLayerImpl.getDataSource(PortabilityLayerImpl.java:655)
        at com.ibm.ejs.cm.JDBC1PhaseRF.createConnectionFactory(JDBC1PhaseRF.java:56)
        at com.ibm.ejs.cm.DataSourceImpl$3.run(DataSourceImpl.java:197)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.ibm.ejs.cm.DataSourceImpl.getSource(DataSourceImpl.java:195)
        at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:122)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:120)
        at com.apl.tas.util.DataConnection.getConnection(DataConnection.java:58)
        at com.apl.tas.data.security.TASSecurity.getLocations(TASSecurity.java:312)
        at com.apl.tas.action.TASLoginServlet.doPost(TASLoginServlet.java:119)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
        at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
        at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
        at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
        at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
        at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
        at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:523)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:282)
        at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:112)
        at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:91)
        at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:184)
        at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
        at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:122)
        at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)
        at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
        at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:323)
        at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)
        at com.ibm.ws.util.CachedThread.run(ThreadPool.java:122)

    ------------------------------
    spy.properties entries

    realdriver=COM.ibm.db2.jdbc.app.DB2Driver
    realdatasource=Realjdbc/P6DB2
    realdatasourceclass=COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource
    realdatasourceproperties=databaseName;MyDB2DB,user;xxxxxx,password;xxxxx,disable2Phase;true

    deregisterdrivers=true