com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR1013E: Exception occured when verifying current backend id DB2UDBNT_V82_1: javax.resource.spi.ResourceAllocationException: DSRA8100E: Unable to get a PooledConnection from the DataSource., error code: JAVAX_CONN_ERR, error code: JAVAX_CONN_ERR
I have successfully configured the datasource in the server(Websphere Express v6) bcoz, when I test the connection from the admin console, it gets successful. I am giving the complete stack trace below. Please help to solve this problem. Thanks in advance :-)
9/21/05 15:13:58:791 IST] 0000002c SystemErr R java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException: ; nested exception is:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR1013E: Exception occured when verifying current backend id DB2UDBNT_V82_1: javax.resource.spi.ResourceAllocationException: DSRA8100E: Unable to get a PooledConnection from the DataSource., error code: JAVAX_CONN_ERR, error code: JAVAX_CONN_ERR
at com.ibm.CORBA.iiop.UtilDelegateImpl.mapSystemException(UtilDelegateImpl.java:162)
at com.ibm.CORBA.iiop.UtilDelegateImpl.wrapException(UtilDelegateImpl.java:684)
at javax.rmi.CORBA.Util.wrapException(Util.java:296)
at com.cambilsoftware.trial._EJSRemoteCMPCsAgentMasterHome_8a31d8d5_Stub.findByPrimaryKey(_EJSRemoteCMPCsAgentMasterHome_8a31d8d5_Stub.java:249)
at com.ibm._jsp._index._jspService(_index.java:85)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:171)
at com.ibm.ws.webcontainer.extension.DefaultExtensionProcessor.handleRequest(DefaultExtensionProcessor.java:399)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2841)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: java.rmi.RemoteException: ; nested exception is:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR1013E: Exception occured when verifying current backend id DB2UDBNT_V82_1: javax.resource.spi.ResourceAllocationException: DSRA8100E: Unable to get a PooledConnection from the DataSource., error code: JAVAX_CONN_ERR, error code: JAVAX_CONN_ERR
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanClassExtensionImpl.createPMException(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanClassExtensionImpl.checkBackendId(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanClassExtensionImpl.binding(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanClassExtensionImpl.checkBinding(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.setPMHomeInfo(Unknown Source)
at com.ibm.ejs.container.ContainerManaged2_0BeanO.<init>(ContainerManaged2_0BeanO.java:160)
at com.ibm.ejs.container.ContainerManaged2_0BeanOFactory.create(ContainerManaged2_0BeanOFactory.java:42)
at com.ibm.ejs.container.EJSHome.createBeanO(EJSHome.java:836)
at com.ibm.ejs.container.EJSHome.createBeanO(EJSHome.java:939)
at com.ibm.ejs.container.activator.OptCEntityActivationStrategy.atActivate(OptCEntityActivationStrategy.java:130)
at com.ibm.ejs.container.activator.Activator.activateBean(Activator.java:593)
at com.ibm.ejs.container.EJSHome.activateBean_Common(EJSHome.java:1659)
at com.ibm.ejs.container.EJSHome.activateBean(EJSHome.java:1500)
at com.cambilsoftware.trial.EJSCMPCsAgentMasterHomeBean_8a31d8d5.findByPrimaryKey(EJSCMPCsAgentMasterHomeBean_8a31d8d5.java:54)
at com.cambilsoftware.trial.EJSRemoteCMPCsAgentMasterHome_8a31d8d5.findByPrimaryKey(EJSRemoteCMPCsAgentMasterHome_8a31d8d5.java:77)
at com.cambilsoftware.trial._EJSRemoteCMPCsAgentMasterHome_8a31d8d5_Stub.findByPrimaryKey(_EJSRemoteCMPCsAgentMasterHome_8a31d8d5_Stub.java:242)
at com.ibm._jsp._index._jspService(_index.java:85)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:171)
at com.ibm.ws.jsp.webcontainerext.JSPExtensionProcessor.handleRequest(JSPExtensionProcessor.java:230)
at com.ibm.ws.webcontainer.extension.DefaultExtensionProcessor.handleRequest(DefaultExtensionProcessor.java:399)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2841)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
Caused by: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR1013E: Exception occured when verifying current backend id DB2UDBNT_V82_1: javax.resource.spi.ResourceAllocationException: DSRA8100E: Unable to get a PooledConnection from the DataSource., error code: JAVAX_CONN_ERR, error code: JAVAX_CONN_ERR
... 40 more
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.CORBA.iiop.UtilDelegateImpl.mapSystemException(UtilDelegateImpl.java:162)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.CORBA.iiop.UtilDelegateImpl.wrapException(UtilDelegateImpl.java:684)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at javax.rmi.CORBA.Util.wrapException(Util.java:296)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.cambilsoftware.trial._EJSRemoteCMPCsAgentMasterHome_8a31d8d5_Stub.findByPrimaryKey(_EJSRemoteCMPCsAgentMasterHome_8a31d8d5_Stub.java:249)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm._jsp._index._jspService(_index.java:85)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:171)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.extension.DefaultExtensionProcessor.handleRequest(DefaultExtensionProcessor.java:399)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2841)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R Caused by: java.rmi.RemoteException: ; nested exception is:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR1013E: Exception occured when verifying current backend id DB2UDBNT_V82_1: javax.resource.spi.ResourceAllocationException: DSRA8100E: Unable to get a PooledConnection from the DataSource., error code: JAVAX_CONN_ERR, error code: JAVAX_CONN_ERR
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanClassExtensionImpl.createPMException(Unknown Source)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanClassExtensionImpl.checkBackendId(Unknown Source)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanClassExtensionImpl.binding(Unknown Source)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanClassExtensionImpl.checkBinding(Unknown Source)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.setPMHomeInfo(Unknown Source)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ejs.container.ContainerManaged2_0BeanO.<init>(ContainerManaged2_0BeanO.java:160)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ejs.container.ContainerManaged2_0BeanOFactory.create(ContainerManaged2_0BeanOFactory.java:42)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ejs.container.EJSHome.createBeanO(EJSHome.java:836)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ejs.container.EJSHome.createBeanO(EJSHome.java:939)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ejs.container.activator.OptCEntityActivationStrategy.atActivate(OptCEntityActivationStrategy.java:130)
[9/21/05 15:13:58:791 IST] 0000002c SystemErr R at com.ibm.ejs.container.activator.Activator.activateBean(Activator.java:593)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ejs.container.EJSHome.activateBean_Common(EJSHome.java:1659)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ejs.container.EJSHome.activateBean(EJSHome.java:1500)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.cambilsoftware.trial.EJSCMPCsAgentMasterHomeBean_8a31d8d5.findByPrimaryKey(EJSCMPCsAgentMasterHomeBean_8a31d8d5.java:54)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.cambilsoftware.trial.EJSRemoteCMPCsAgentMasterHome_8a31d8d5.findByPrimaryKey(EJSRemoteCMPCsAgentMasterHome_8a31d8d5.java:77)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.cambilsoftware.trial._EJSRemoteCMPCsAgentMasterHome_8a31d8d5_Stub.findByPrimaryKey(_EJSRemoteCMPCsAgentMasterHome_8a31d8d5_Stub.java:242)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm._jsp._index._jspService(_index.java:85)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:88)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:171)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.jsp.webcontainerext.JSPExtensionProcessor.handleRequest(JSPExtensionProcessor.java:230)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.extension.DefaultExtensionProcessor.handleRequest(DefaultExtensionProcessor.java:399)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2841)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R Caused by: com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR1013E: Exception occured when verifying current backend id DB2UDBNT_V82_1: javax.resource.spi.ResourceAllocationException: DSRA8100E: Unable to get a PooledConnection from the DataSource., error code: JAVAX_CONN_ERR, error code: JAVAX_CONN_ERR
[9/21/05 15:13:58:807 IST] 0000002c SystemErr R ... 40 more
good luck
<cmpConnectionFactory xmi:id="CMPConnectionFactoryBinding_1069438771634" jndiName="jdbc/derby/dualDataSource" resAuth="Container">
<properties xmi:id="Property_1192227906764" name="com.ibm.mapping.authDataAlias" value="username" description="container-managed auth alias from resource-ref"/>
</cmpConnectionFactory>