Ken,

If the ConnectionManager in Websphere says the state is SATE_TRAN_WRAPPER_INUSE, is that mean it is actively communicating with database? Or in the connection pool it is not free?

Here is one trace message

5/6/08 12:01:39:547 EDT 00000018 ConnLeakLogic 3 MCWrapper id 6cbd9138 Managed connection WSRdbManagedConnectionImpl@11892b4e State:STATE_TRAN_WRAPPER_INUSE Thread Id: 88ffafa Thread Name: server.start

up : 0 Handle count 0

in-use for 181051ms

java.lang.Throwable

at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:762 )

at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java: 439)

at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java: 408)

..........................................................

at javax.servlet.GenericServlet.init(GenericServlet.java:256)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:192)

at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.init(ServletWrapper.java:319)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.initialize(ServletWrapper.java:1 221)

at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.initialize(ServletWrapper.java :152)

at com.ibm.wsspi.webcontainer.extension.WebExtensionProcessor.createServletWrapper (WebExtensionProcessor.java:99)

at com.ibm.ws.webcontainer.webapp.WebApp.getServletWrapper(WebApp.java:828)

at com.ibm.ws.webcontainer.webapp.WebApp.initializeTargetMappings(WebApp.java:483)

at com.ibm.ws.webcontainer.webapp.WebApp.commonInitializationFinish(WebApp.java:32 0)

at com.ibm.ws.wswebcontainer.webapp.WebApp.initialize(WebApp.java:290)

at com.ibm.ws.wswebcontainer.webapp.WebGroup.addWebApplication(WebGroup.java:90)
at com.ibm.ws.wswebcontainer.VirtualHost.addWebApplication(VirtualHost.java:157)
at com.ibm.ws.wswebcontainer.WebContainer.addWebApp(WebContainer.java:665)

at com.ibm.ws.wswebcontainer.WebContainer.addWebApplication(WebContainer.java:618)

at com.ibm.ws.webcontainer.component.WebContainerImpl.install(WebContainerImpl.jav a:335)

at com.ibm.ws.webcontainer.component.WebContainerImpl.start(WebContainerImpl.java: 551)

at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1 303)

at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(De ployedApplicationImpl.java:1138)

at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:5 69)

at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationI mpl.java:817)

at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgr Impl.java:949)

at com.ibm.ws.runtime.component.ApplicationMgrImpl$AppInitializer.run(ApplicationM grImpl.java:2122)

at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsCompon entImpl.java:342)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)