Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

no value for Real Data Source Name, cannot perform jndi

Posted on 2007-07-23
5
Medium Priority
?
1,507 Views
Last Modified: 2013-12-11
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=
0
Comment
Question by:chaitu chaitu
  • 3
  • 2
5 Comments
 
LVL 41

Expert Comment

by:HonorGod
ID: 19555488
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
 
LVL 20

Author Comment

by:chaitu chaitu
ID: 19555607
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
 
LVL 41

Accepted Solution

by:
HonorGod earned 1500 total points
ID: 19557488
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
 
LVL 20

Author Comment

by:chaitu chaitu
ID: 19588142
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
 
LVL 41

Expert Comment

by:HonorGod
ID: 20327160
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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Verbose logging is used to diagnose garbage collector problems. By default, -verbose:gc output is written to either native_stderr.log or native_stdout.log.   It is also possible to redirect the logs to a user-specified file. This article will de…
This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month20 days, 19 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question