| Error Getting comunicating studio with oracle [message #91849] |
Thu, 24 April 2003 00:23  |
Suresh Babu
Messages: 3
Registered: April 2003
|
Junior Member |
|
|
Hi.
I getting this error when i communicating websphere studio with oracle database for EJB application
Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/Oracle/ClaimNet, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a PooledConnection from the DataSource.
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:251)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:172)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:182)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:663)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:189)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:503)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1106)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:897)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1065)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:560)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:374)
at com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl.getConnection(WSRdbConnectionFactoryImpl.java:217)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.getConnection(WSRelationalRAAdapter.java:472)
at com.ibm.ws.ejbpersistence.cache.TransactionListenerImpl.getConnection(TransactionListenerImpl.java:223)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.executeOneRowFBPK(DataAccessRequestImpl.java:246)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.fetchRecordFromDataStore(ConcreteBeanStatefulInstanceExtensionImpl.java:262)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.getRecordForLoad(ConcreteBeanStatefulInstanceExtensionImpl.java:216)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.executeLoad(CBStatefulPersistor.java:281)
at com.ibm.ws.ejbpersistence.beanextensions.CBReadyState.ejbLoad(CBReadyState.java:29)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.ejbLoad(CBStatefulPersistor.java:116)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbLoad(ConcreteBeanStatefulInstanceExtensionImpl.java:148)
at com.imantras.claimnet.backend.Supplier.ConcreteStatus_f36edef8.ejbLoad(ConcreteStatus_f36edef8.java:84)
at com.ibm.ejs.container.ContainerManaged2_0BeanO.loadForEnlist(ContainerManaged2_0BeanO.java:319)
at com.ibm.ejs.container.EntityBeanO.enlist(EntityBeanO.java:700)
at com.ibm.ejs.container.activator.OptCEntityActivationStrategy.atActivate(OptCEntityActivationStrategy.java:118)
at com.ibm.ejs.container.activator.Activator.activateBean(Activator.java:518)
at com.ibm.ejs.container.EJSHome.activateBean_Common(EJSHome.java:1216)
at com.ibm.ejs.container.EJSHome.activateBean_Local(EJSHome.java:1130)
at com.imantras.claimnet.backend.Supplier.EJSCMPStatusHomeBean_f36edef8.findByPrimaryKey_Local(EJSCMPStatusHomeBean_f36edef8.java:89)
at com.imantras.claimnet.backend.Supplier.EJSLocalCMPStatusHome_f36edef8.findByPrimaryKey(EJSLocalCMPStatusHome_f36edef8.java:99)
at com.imantras.claimnet.backend.Supplier.SupplierManagementSessionBean.registerSupplier(SupplierManagementSessionBean.java:91)
at com.imantras.claimnet.backend.Supplier.EJSLocalStatelessSupplierManagementSession_1b8a5267.registerSupplier(EJSLocalStatelessSupplierManagementSession_1b8a5267.java:45)
at com.imantras.claimnet.backend.GateKeeperSessionBean.dispatchToRegisterSupplier(GateKeeperSessionBean.java:320)
at com.imantras.claimnet.backend.GateKeeperSessionBean.attemptFunction(GateKeeperSessionBean.java:153)
at com.imantras.claimnet.backend.EJSRemoteStatelessGateKeeperSession_36b09eb8.attemptFunction(EJSRemoteStatelessGateKeeperSession_36b09eb8.java:76)
at com.imantras.claimnet.backend._GateKeeperSession_Stub.attemptFunction(_GateKeeperSession_Stub.java:303)
at com.imantras.claimnet.DBHome.common.GateKeeperUtil.attemptFunction(GateKeeperUtil.java:108)
at com.imantras.claimnet.suppliercapture.register.SupplierRegisterAction.registerSupplier(SupplierRegisterAction.java:137)
at com.imantras.claimnet.suppliercapture.register.SupplierRegisterAction.perform(SupplierRegisterAction.java:102)
at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
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:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)
---- Begin backtrace for nested exception
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:263)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:543)
at java.sql.DriverManager.getConnection(DriverManager.java:194)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:111)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:98)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:77)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:61)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:643)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:638)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:189)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:503)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1106)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:897)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1065)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:560)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:374)
at com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl.getConnection(WSRdbConnectionFactoryImpl.java:217)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.getConnection(WSRelationalRAAdapter.java:472)
at com.ibm.ws.ejbpersistence.cache.TransactionListenerImpl.getConnection(TransactionListenerImpl.java:223)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.executeOneRowFBPK(DataAccessRequestImpl.java:246)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.fetchRecordFromDataStore(ConcreteBeanStatefulInstanceExtensionImpl.java:262)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.getRecordForLoad(ConcreteBeanStatefulInstanceExtensionImpl.java:216)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.executeLoad(CBStatefulPersistor.java:281)
at com.ibm.ws.ejbpersistence.beanextensions.CBReadyState.ejbLoad(CBReadyState.java:29)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.ejbLoad(CBStatefulPersistor.java:116)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbLoad(ConcreteBeanStatefulInstanceExtensionImpl.java:148)
at com.imantras.claimnet.backend.Supplier.ConcreteStatus_f36edef8.ejbLoad(ConcreteStatus_f36edef8.java:84)
at com.ibm.ejs.container.ContainerManaged2_0BeanO.loadForEnlist(ContainerManaged2_0BeanO.java:319)
at com.ibm.ejs.container.EntityBeanO.enlist(EntityBeanO.java:700)
at com.ibm.ejs.container.activator.OptCEntityActivationStrategy.atActivate(OptCEntityActivationStrategy.java:118)
at com.ibm.ejs.container.activator.Activator.activateBean(Activator.java:518)
at com.ibm.ejs.container.EJSHome.activateBean_Common(EJSHome.java:1216)
at com.ibm.ejs.container.EJSHome.activateBean_Local(EJSHome.java:1130)
at com.imantras.claimnet.backend.Supplier.EJSCMPStatusHomeBean_f36edef8.findByPrimaryKey_Local(EJSCMPStatusHomeBean_f36edef8.java:89)
at com.imantras.claimnet.backend.Supplier.EJSLocalCMPStatusHome_f36edef8.findByPrimaryKey(EJSLocalCMPStatusHome_f36edef8.java:99)
at com.imantras.claimnet.backend.Supplier.SupplierManagementSessionBean.registerSupplier(SupplierManagementSessionBean.java:91)
at com.imantras.claimnet.backend.Supplier.EJSLocalStatelessSupplierManagementSession_1b8a5267.registerSupplier(EJSLocalStatelessSupplierManagementSession_1b8a5267.java:45)
at com.imantras.claimnet.backend.GateKeeperSessionBean.dispatchToRegisterSupplier(GateKeeperSessionBean.java:320)
at com.imantras.claimnet.backend.GateKeeperSessionBean.attemptFunction(GateKeeperSessionBean.java:153)
at com.imantras.claimnet.backend.EJSRemoteStatelessGateKeeperSession_36b09eb8.attemptFunction(EJSRemoteStatelessGateKeeperSession_36b09eb8.java:76)
at com.imantras.claimnet.backend._GateKeeperSession_Stub.attemptFunction(_GateKeeperSession_Stub.java:303)
at com.imantras.claimnet.DBHome.common.GateKeeperUtil.attemptFunction(GateKeeperUtil.java:108)
at com.imantras.claimnet.suppliercapture.register.SupplierRegisterAction.registerSupplier(SupplierRegisterAction.java:137)
at com.imantras.claimnet.suppliercapture.register.SupplierRegisterAction.perform(SupplierRegisterAction.java:102)
at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
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:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)
Next Linked Exception:
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
