Error when we try to load the datasource

Discussions

EJB programming & troubleshooting: Error when we try to load the datasource

  1. Error when we try to load the datasource (3 messages)

    Hi all,

    We create a EJB project with oracle 9i database, when we execute the application and, for example, from our session bean we try to call a findByPrimaryKey() method over our entity bean, the container load the datasource (the database is configured as 'desa' ) and show the
    following error :

    FreePool J2CA0046E: The method
                 createManagedConnctionWithMCWrapper got a
                 exception when create a ManagedConnection
                 for resource jdbc/desa, genering
                 ResourceAllocationException.

    Original exception: com.ibm.ws.exception.WsException:
                   DSRA8100E: Unable to get a PooledConnection
                   from the DataSource.

    Nested exception is: javax.ejb.EJBException:
     nested exception is:
    com.ibm.ws.ejbpersistence.utilpm.ResourceAdapterException:
          PMGR6020E: Error when connect with
               com.ibm.ws.rsadapter.cci.
               WSRdbConnectionFactoryImpl@1687178e adapter

     We´re working with websphere 5. We defined the datasource on websphere with all required parameters.
     I don't know what could be happening.

    Thanks and regards!

    Threaded Messages (3)

  2. connection pooling[ Go to top ]

    "Original exception: com.ibm.ws.exception.WsException:
                   DSRA8100E: Unable to get a PooledConnection
                   from the DataSource. "

    Have you configured the connection pooling for your db?
    If not, please do so with enough capacity.

    Kiran
  3. connection pooling - Connction typo[ Go to top ]

    Hi there,
    Using WSAD 5.1.2, I am getting a long trace of exceptions executing database call to Cloudscape and looking at the trace,
     
    createManagedConnctionWithMCWrapper‡¾com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a PooledConnection from the DataSource.
     
    It looks to me Connction should be Connection.
    Maybe a typo.
  4. Solution[ Go to top ]

    http://www-1.ibm.com/support/docview.wss?rs=0&uid=swg24006334