Topic
7 replies Latest Post - ‏2012-02-10T14:57:30Z by kumar11
SystemAdmin
SystemAdmin
6043 Posts
ACCEPTED ANSWER

Pinned topic Unable to get a PooledConnection from the DataSource for DB2 Database

‏2005-09-21T10:03:57Z |
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
Updated on 2012-02-10T14:57:30Z at 2012-02-10T14:57:30Z by kumar11
  • migs_peritus
    migs_peritus
    1 Post
    ACCEPTED ANSWER

    Re: Unable to get a PooledConnection from the DataSource for DB2 Database

    ‏2005-10-17T23:10:50Z  in response to SystemAdmin
    I'm having exactly the same problem.
    Did you find any solution ?
    Thanks.
    • SystemAdmin
      SystemAdmin
      6043 Posts
      ACCEPTED ANSWER

      Re: Unable to get a PooledConnection from the DataSource for DB2 Database

      ‏2006-04-12T16:04:15Z  in response to migs_peritus
      Did you resolve this problem?
  • SystemAdmin
    SystemAdmin
    6043 Posts
    ACCEPTED ANSWER

    Re: Unable to get a PooledConnection from the DataSource for DB2 Database

    ‏2006-04-26T18:19:03Z  in response to SystemAdmin
    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
    • kumar11
      kumar11
      1 Post
      ACCEPTED ANSWER

      Re: Unable to get a PooledConnection from the DataSource for DB2 Database

      ‏2012-02-10T14:57:30Z  in response to SystemAdmin
      in our application we are not using EJB, but we are facing same issue.
  • SystemAdmin
    SystemAdmin
    6043 Posts
    ACCEPTED ANSWER

    Re: Unable to get a PooledConnection from the DataSource for DB2 Database

    ‏2006-12-05T19:42:30Z  in response to SystemAdmin
    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.
    • SystemAdmin
      SystemAdmin
      6043 Posts
      ACCEPTED ANSWER

      Re: Unable to get a PooledConnection from the DataSource for DB2 Database

      ‏2006-12-28T13:17:41Z  in response to SystemAdmin
      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.
  • SystemAdmin
    SystemAdmin
    6043 Posts
    ACCEPTED ANSWER

    Re: Unable to get a PooledConnection from the DataSource for DB2 Database

    ‏2007-10-13T00:46:28Z  in response to SystemAdmin
    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>