|
Home > Archive > WebSphere Application Server > April 2005 > Problem tracing DB2 in WAS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem tracing DB2 in WAS
|
|
|
| Hi,
We are having some issues with our application and we think the problem is related to locks in our DB2 database. I tried setting up tracing within WAS to see when connections are made etc but am having some troubles. I am receiving a java.lang.NoClassDefF
oundError when it tries to establish a connection. Has anyone seen this before or could offer some suggestions on how to fix this.
I have modified the Diagnostic trace to log:
com.ibm.ws.database.logwriter=all=enabled:com.ibm.ws.db2.logwriter=all=enabled
I have also set custom properties in the DataSource:
- traceFile D:\Data\trace.log
- traceLevel -1
- traceFileAppend true
We are using the DB2 Universal JDBC Provider:
Implementation Classname: COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource
DB2 library: db2java.zip
Datasource helper class name : com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
When I start our application I get the following execption trace:
[26/04/05 15:41:47:422 EST] 16b02292 ServletInstan E SRVE0100E: Did not realize init() exception thrown by servlet action: javax.servlet.ServletException: com/ibm/db2/jcc/DB2Connection
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletInstance.java:99)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycleServlet.java:147)
at com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecycleServlet.java:270)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleServlet.java:113)
at com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:189)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServletManager.java:876)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:224)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager. getServletReference(WebAppServletManager
.java:455)
at com.ibm.ws.webcontainer.webapp.WebApp.getServletReference(WebApp.java:652)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcherInfo. calculateInfo(WebAppRequestDispatcherInf
o.java:187)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcherInfo.<init>(WebAppRequestDispatcherInfo.java:68)
at com.ibm.ws.webcontainer.webapp.WebApp.getRequestDispatcher(WebApp.java:1464)
at com.ibm.ws.webcontainer.webapp.WebApp.getRequestDispatcher(WebApp.java:1423)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:615)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:449)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912)
---- Begin backtrace for Nested Throwables
java.lang.NoClassDefFoundError: com/ibm/db2/jcc/DB2Connection
at com.ibm.ws.rsadapter.spi.InternalDB2UniversalDataStoreHelper. enableJdbcLogging(InternalDB2UniversalDa
taStoreHelper.java:350)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl. getConnection(WSRdbManagedConnectionImpl
.java:2014)
at com.ibm.ejs.j2c.MCWrapper.getConnection(MCWrapper.java:1496)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:474)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:241)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:214)
at au.gov.defence.msr.utility.JDBCFactory.getConnection(JDBCFactory.java:127)
at au.gov.defence.msr.web.defaults.DataDefaultsBean.refreshDataSource(DataDefaultsBean.java:896)
at au.gov.defence.msr.web.monitor.DataDefaultsUpdater.performUpdate(DataDefaultsUpdater.java:143)
at au.gov.defence.msr.plugin.MsrPlugin.setupDataDefaults(MsrPlugin.java:270)
at au.gov.defence.msr.plugin.MsrPlugin.config(MsrPlugin.java:166)
at au.gov.defence.msr.plugin.MsrPlugin.init(MsrPlugin.java:93)
at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:1158)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:473)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletInstance.java:82)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycleServlet.java:147)
at com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecycleServlet.java:270)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleServlet.java:113)
at com.ibm.ws.webcontainer.servlet.ServletInstance.init(ServletInstance.java:189)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.addServlet(WebAppServletManager.java:876)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:224)
at com.ibm.ws.webcontainer.webapp.WebAppServletManager. getServletReference(WebAppServletManager
.java:455)
at com.ibm.ws.webcontainer.webapp.WebApp.getServletReference(WebApp.java:652)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcherInfo. calculateInfo(WebAppRequestDispatcherInf
o.java:187)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcherInfo.<init>(WebAppRequestDispatcherInfo.java:68)
at com.ibm.ws.webcontainer.webapp.WebApp.getRequestDispatcher(WebApp.java:1464)
at com.ibm.ws.webcontainer.webapp.WebApp.getRequestDispatcher(WebApp.java:1423)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:615)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:449)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912)
Thanks
| |
|
| Actually the error is:
"
> ---- Begin backtrace for Nested Throwables
> java.lang.NoClassDefFoundError: com/ibm/db2/jcc/DB2Connection
"
So there is few to expect from the tracing of DB2, because the DB2 driver is
not found yet...
You need to tune the classpath to make the driver available to the
application.
|
|
|
|
|