Java Help

anand_sridhar · 07-06-2005, 08:14 AM

Hi there,
I am trying to connect to oracle data base through Java and am getting the following exception. Funny thing is for the same configuration, it is coming for some and not for others.
Can any one help me out..??

I have the exception printed below..

E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/rosetta/protected/toolkit/toolkitDataSource, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a PooledConnection from the DataSource.
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterEx ception.<init>(DataStoreAdapterException.java:244)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterEx ception.<init>(DataStoreAdapterException.java:171)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAd apterException(AdapterUtil.java:208)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPool edConnection(DSConfigurationHelper.java:706)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooled Connection(WSRdbDataSource.java:487)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.createManagedConnection(WSManagedConnectionF actoryImpl.java:577)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManaged ConnectionWithMCWrapper(FreePool.java:1280)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitF orConnection(FreePool.java:1064)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(Po olManager.java:1571)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrappe r(ConnectionManager.java:622)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnecti on(ConnectionManager.java:424)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java:216)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java:308)
at com.lxnx.ols.toolkit.dp.StateDataSource.createConn ection(StateDataSource.java:86)
at com.lxnx.ols.toolkit.dp.UniqueSequence.assign(Uniq ueSequence.java:97)
at com.lxnx.ols.toolkit.dp.AutoGenerateDataDescriptor .<init>(AutoGenerateDataDescriptor.java:133)
at com.lxnx.ols.toolkit.statemgmt.StateManager.genera teKey(StateManager.java:1005)
at com.lxnx.ols.toolkit.statemgmt.StateManager.storeW orkflowBean(StateManager.java:330)
at com.lxnx.ols.rosetta.framework.returnto.ReturnToUt ils.saveReturnToContext(ReturnToUtils.java:48)
at com.lxnx.ols.rosetta.search.controller.SrchFormRen dererAction.buildReturnTo(SrchFormRendererAction.j ava:1063)
at com.lxnx.ols.rosetta.search.controller.SrchFormRen dererAction.prepareViewBean(SrchFormRendererAction .java:590)
at com.lxnx.ols.rosetta.search.controller.SrchFormRen dererAction.executeLogic(SrchFormRendererAction.ja va:329)
at com.lxnx.ols.toolkit.struts.action.BaseAction.exec ute(BaseAction.java:103)
at org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:421)
at com.lxnx.ols.toolkit.struts.plugins.actionplugin.A ctionPlugInTilesRequestProcessor.processActionPerf orm(ActionPlugInTilesRequestProcessor.java:116)
at com.lxnx.ols.toolkit.struts.action.LNTilesRequestP rocessor.processActionPerform(LNTilesRequestProces sor.java:66)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1164)
at com.lxnx.ols.toolkit.struts.action.LNActionServlet .process(LNActionServlet.java:107)
at com.lxnx.ols.rosetta.framework.struts.RosettaActio nServlet.process(RosettaActionServlet.java:73)
at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.ServicingServletSt ate.service(StrictLifecycleServlet.java:333)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:969)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:200)
at org.apache.struts.action.RequestProcessor.doForwar d(RequestProcessor.java:1056)
at org.apache.struts.tiles.TilesRequestProcessor.doFo rward(TilesRequestProcessor.java:261)
at com.lxnx.ols.toolkit.struts.action.LNTilesRequestP rocessor.doForward(LNTilesRequestProcessor.java:16 8)
at org.apache.struts.action.RequestProcessor.processF orwardConfig(RequestProcessor.java:388)
at org.apache.struts.tiles.TilesRequestProcessor.proc essForwardConfig(TilesRequestProcessor.java:316)
at com.lxnx.ols.toolkit.struts.action.LNTilesRequestP rocessor.processForwardConfig(LNTilesRequestProces sor.java:125)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:231)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1164)
at com.lxnx.ols.toolkit.struts.action.LNActionServlet .process(LNActionServlet.java:107)
at com.lxnx.ols.rosetta.framework.struts.RosettaActio nServlet.process(RosettaActionServlet.java:73)
at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.ServicingServletSt ate.service(StrictLifecycleServlet.java:333)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:969)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:200)
at org.apache.struts.action.RequestProcessor.doForwar d(RequestProcessor.java:1056)
at org.apache.struts.tiles.TilesRequestProcessor.doFo rward(TilesRequestProcessor.java:261)
at com.lxnx.ols.toolkit.struts.action.LNTilesRequestP rocessor.doForward(LNTilesRequestProcessor.java:16 8)
at org.apache.struts.action.RequestProcessor.processF orwardConfig(RequestProcessor.java:388)
at org.apache.struts.tiles.TilesRequestProcessor.proc essForwardConfig(TilesRequestProcessor.java:316)
at com.lxnx.ols.toolkit.struts.action.LNTilesRequestP rocessor.processForwardConfig(LNTilesRequestProces sor.java:125)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:231)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1164)
at com.lxnx.ols.toolkit.struts.action.LNActionServlet .process(LNActionServlet.java:107)
at com.lxnx.ols.rosetta.framework.struts.RosettaActio nServlet.process(RosettaActionServlet.java:73)
at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.ServicingServletSt ate.service(StrictLifecycleServlet.java:333)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:969)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:200)
at org.apache.struts.action.RequestProcessor.doForwar d(RequestProcessor.java:1056)
at org.apache.struts.tiles.TilesRequestProcessor.doFo rward(TilesRequestProcessor.java:261)
at com.lxnx.ols.toolkit.struts.action.LNTilesRequestP rocessor.doForward(LNTilesRequestProcessor.java:16 8)
at org.apache.struts.action.RequestProcessor.processF orwardConfig(RequestProcessor.java:388)
at org.apache.struts.tiles.TilesRequestProcessor.proc essForwardConfig(TilesRequestProcessor.java:316)
at com.lxnx.ols.toolkit.struts.action.LNTilesRequestP rocessor.processForwardConfig(LNTilesRequestProces sor.java:125)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:231)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1164)
at com.lxnx.ols.toolkit.struts.action.LNActionServlet .process(LNActionServlet.java:107)
at com.lxnx.ols.rosetta.framework.struts.RosettaActio nServlet.process(RosettaActionServlet.java:73)
at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:76)
at com.lxnx.ols.tools.SessionMeterFilter.doFilter(Ses sionMeterFilter.java:50)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapp er.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:71)
at com.lxnx.ols.rosetta.pt.PassThruCleanupFilter.doFi lter(PassThruCleanupFilter.java:41)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapp er.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:71)
at com.lxnx.ols.tools.SessionMeterFilter.doFilter(Ses sionMeterFilter.java:50)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapp er.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:71)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:965)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:200)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForwar d(WebAppInvoker.java:119)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleIn vocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInv ocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcesso r.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDis patcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handle Request(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleReques t(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection. java:443)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:593)
Caused by: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=1 2505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleC onnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInsta nce(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:314)
at java.sql.DriverManager.getConnection(DriverManager .java:538)
at java.sql.DriverManager.getConnection(DriverManager .java:157)
at oracle.jdbc.pool.OracleDataSource.getConnection(Or acleDataSource.java:169)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.ge tPhysicalConnection(OracleConnectionPoolDataSource .java:149)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.ge tPooledConnection(OracleConnectionPoolDataSource.j ava:95)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(D SConfigurationHelper.java:688)
at com.ibm.ws.security.util.AccessController.doPrivil eged(AccessController.java:111)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPool edConnection(DSConfigurationHelper.java:683)
... 127 more
---- Begin backtrace for nested exception
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=1 2505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleC onnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInsta nce(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:314)
at java.sql.DriverManager.getConnection(DriverManager .java:538)
at java.sql.DriverManager.getConnection(DriverManager .java:157)
at oracle.jdbc.pool.OracleDataSource.getConnection(Or acleDataSource.java:169)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.ge tPhysicalConnection(OracleConnectionPoolDataSource .java:149)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.ge tPooledConnection(OracleConnectionPoolDataSource.j ava:95)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(D SConfigurationHelper.java:688)
at com.ibm.ws.security.util.AccessController.doPrivil eged(AccessController.java:111)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPool edConnection(DSConfigurationHelper.java:683)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooled Connection(WSRdbDataSource.java:487)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.createManagedConnection(WSManagedConnectionF actoryImpl.java:577)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManaged ConnectionWithMCWrapper(FreePool.java:1280)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitF orConnection(FreePool.java:1064)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(Po olManager.java:1571)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrappe r(ConnectionManager.java:622)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnecti on(ConnectionManager.java:424)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java:216)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConn ection(WSJdbcDataSource.java:308)
at com.lxnx.ols.toolkit.dp.StateDataSource.createConn ection(StateDataSource.java:86)
at com.lxnx.ols.toolkit.dp.UniqueSequence.assign(Uniq ueSequence.java:97)
at com.lxnx.ols.toolkit.dp.AutoGenerateDataDescriptor .<init>(AutoGenerateDataDescriptor.java:133)
at com.lxnx.ols.toolkit.statemgmt.StateManager.genera teKey(StateManager.java:1005)
at com.lxnx.ols.toolkit.statemgmt.StateManager.storeW orkflowBean(StateManager.java:330)
at com.lxnx.ols.rosetta.framework.returnto.ReturnToUt ils.saveReturnToContext(ReturnToUtils.java:48)
at com.lxnx.ols.rosetta.search.controller.SrchFormRen dererAction.buildReturnTo(SrchFormRendererAction.j ava:1063)
at com.lxnx.ols.rosetta.search.controller.SrchFormRen dererAction.prepareViewBean(SrchFormRendererAction .java:590)
at com.lxnx.ols.rosetta.search.controller.SrchFormRen dererAction.executeLogic(SrchFormRendererAction.ja va:329)
at com.lxnx.ols.toolkit.struts.action.BaseAction.exec ute(BaseAction.java:103)
at org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:421)
at com.lxnx.ols.toolkit.struts.plugins.actionplugin.A ctionPlugInTilesRequestProcessor.processActionPerf orm(ActionPlugInTilesRequestProcessor.java:116)
at com.lxnx.ols.toolkit.struts.action.LNTilesRequestP rocessor.processActionPerform(LNTilesRequestProces sor.java:66)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1164)
at com.lxnx.ols.toolkit.struts.action.LNActionServlet .process(LNActionServlet.java:107)
at com.lxnx.ols.rosetta.framework.struts.RosettaActio nServlet.process(RosettaActionServlet.java:73)
at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.ServicingServletSt ate.service(StrictLifecycleServlet.java:333)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:969)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:200)
at org.apache.struts.action.RequestProcessor.doForwar d(RequestProcessor.java:1056)
at org.apache.struts.tiles.TilesRequestProcessor.doFo rward(TilesRequestProcessor.java:261)
at

Member Login