Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Unable to get a PooledConnection from the DataSource for DB2 Database

164 views
Skip to first unread message

nir...@cambilsoftware.com

unread,
Sep 21, 2005, 6:03:57 AM9/21/05
to
Hi,
I am trying to access a table in DB2 Universal Database v 8.2 from a CMP. but when I call findByPrimaryKey() method I am getting the following exception:

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

mju...@us.ibm.com

unread,
Oct 17, 2005, 7:10:50 PM10/17/05
to
I'm having exactly the same problem.
Did you find any solution ?
Thanks.

giuk...@libero.it

unread,
Apr 12, 2006, 12:04:15 PM4/12/06
to
Did you resolve this problem?

abuna...@yahoo.com

unread,
Apr 26, 2006, 2:19:03 PM4/26/06
to
In addition to configuring datasource in the server configuration you need to go to EJB tab in server configuration and specify the "Default data source"..

good luck

jb0...@gmail.com

unread,
Dec 5, 2006, 2:42:30 PM12/5/06
to
well i don't see why logically that selecting a defualt datasource would solve this problem. The problem at hand seems to be a configuration problem and it could be an idiosyncracy of your app server or the way your app sends data.

sri.h...@wipro.com

unread,
Dec 28, 2006, 8:17:41 AM12/28/06
to
These exceptions can occur when your database is having more than one connection. If ur are trying to connect from EJB, check if all the connections to the database are closed. before starting the server ensure that ur db2 is not having any connections.

boz...@vsp.com

unread,
Oct 12, 2007, 8:46:28 PM10/12/07
to
I had the similar problem when I use CMP with derby. I had to edit ibm-ejb-jar-bnd.xmi to overcome the problem. I have removed the xml attribute called loginConfigurationName="DefaultPrincipalMapping" from cmpConnectionFactory element, which resolved my problem.

<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>

ch.va...@gmail.com

unread,
May 9, 2016, 7:37:10 AM5/9/16
to
Hi,

I have the problem while connecting our application with DB2 V10.5.5 , from the Websphere 8.5.5 we are able to connect to the datasource.

com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR1013E: Exception occured when verifying current backend id DB2UDBNT_V95_1: javax.resource.spi.ResourceAllocationException: DSRA8100E: Unable to get a PooledConnection from the DataSource
0 new messages