no value for Real Data Source Name, cannot perform jndi

when i installed p6spy in websphere6.1 i am getting following exception.

 java.sql.SQLException: P6DataSource: no value for Real Data Source Name, cannot perform jndi lookupDSRA0010E: SQL State = null, Error Code = 0;

i am connecting to oracle database;what properties should i set for these parameters in spy.properties file;

realdatasource=
realdatasourceclass=
realdatasourceproperties=
LVL 20
chaitu chaituAsked:
Who is Participating?
 
HonorGodSoftware EngineerCommented:
Well, the values would depend upon your WebSphere settings.  I don't know anything about p6spy since I haven't used it.  However, it sounds like you might be able to use information about "application clients", since they allow stand-alone Java applications to access WebSphere resources remotely.  This includes datasources.  So, I suggest that you take a look at this documentation:

http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.base.doc/info/aes/ae/tcli_developjava.html
0
 
HonorGodSoftware EngineerCommented:
The p6spy documentation includes some information about WebSphere (but specific to version 4, which is ancient)
http://www.p6spy.com/documentation/install.htm#websphere

The WebSphere 6.1 documentation is available from here:
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp

and the information about setting up the database settings is available here:
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.base.doc/info/aes/ae/uprs_rdatabase_settings.html

hopefully this is what you need.
0
 
chaitu chaituAuthor Commented:
what i want to ask you is in spy.properties file for the below parameter what value should i set if my database is Oracle.

realdatasourceproperties=

in the documentation if the database is mysql then they r setting like this:

realdatasourceproperties=port;3306,serverName;myhost
0
 
chaitu chaituAuthor Commented:
i configured all things but below error is coming..



 0000001c DataSourceCon E   DSRA8040I: Failed to connect to the DataSource.  Encountered "": java.sql.SQLException: Connection not available, Timed out waiting for 180000DSRA0010E: SQL State = null, Error Code = 0DSRA0010E: SQL State = null, Error Code = 0DSRA0010E: SQL State = null, Error Code = 0DSRA0010E: SQL State = null, Error Code = 0DSRA0010E: SQL State = null, Error Code = 0DSRA0010E: SQL State = null, Error Code = 0DSRA0010E: SQL State = null, Error Code = 0DSRA0010E: SQL State = null, Error Code = 0DSRA0010E: SQL State = null, Error Code = 0DSRA0010E: SQL State = null, Error Code = 0DSRA0010E: SQL State = null, Error Code = 0
      at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1233)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:444)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1181)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
      at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1793)
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1541)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1181)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
      at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1793)
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1541)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1181)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
      at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1793)
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1541)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1181)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
      at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1793)
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1541)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1181)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
      at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1793)
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1541)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1181)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
      at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1793)
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1541)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1181)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
      at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1793)
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1541)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1181)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
      at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1793)
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1541)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1181)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
      at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1793)
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1541)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:897)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:892)
      at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1181)
      at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1047)
      at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1793)
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1541)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
      at com.p6spy.engine.spy.P6DataSource.getConnection(P6DataSource.java:353)
      at com.p6spy.engine.spy.P6ConnectionPoolDataSource.getPooledConnection(P6ConnectionPoolDataSource.java:112)
      at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1138)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1133)
      at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2356)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:615)
      at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:532)
      at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:460)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:615)
      at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:62)
      at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:615)
      at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:265)
      at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1089)
      at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:971)
      at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:231)
      at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:238)
      at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:833)
      at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:802)
      at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1080)
      at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
      at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:973)
      at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testNode(ResourceMBeanHelper.java:818)
      at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testConnection(ResourceMBeanHelper.java:257)
      at com.ibm.ws.console.resources.database.jdbc.DataSourceCollectionAction.execute(DataSourceCollectionAction.java:408)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:528)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:930)
      at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)
      at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
      at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:761)
      at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:673)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:498)
      at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:308)
      at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1070)
      at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:273)
      at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
      at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:319)
      at com.ibm.isclite.container.controller.InformationController.processForwardConfig(InformationController.java:159)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:528)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:930)
      at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
      at com.ibm.ws.console.core.servlet.WSCUrlFilter.setUpCommandAssistence(WSCUrlFilter.java:792)
      at com.ibm.ws.console.core.servlet.WSCUrlFilter.continueStoringTaskState(WSCUrlFilter.java:363)
      at com.ibm.ws.console.core.servlet.WSCUrlFilter.doFilter(WSCUrlFilter.java:229)
      at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
      at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
      at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
      at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:761)
      at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:673)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:498)
      at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
      at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3163)
      at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:254)
      at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
      at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
      at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:100)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
      at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
      at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1815)
      at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
      at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
      at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
      at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
      at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
      at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
      at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
      at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
Caused by: com.ibm.websphere.ce.j2c.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000
      at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1494)
      at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2145)
      at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
      at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
      ... 229 more
0
 
HonorGodSoftware EngineerCommented:
I'm sorry that I missed the follow up information that you provided.  Thanks for the points.  I hope that you were able to get the issue resolved.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.