How to configure oracle datasource for the use of ejbs? - Websphere

This is a discussion on How to configure oracle datasource for the use of ejbs? - Websphere ; hai every body, i am trying to use oracle for my ejb project. i am able to connect to the database in the database perspective. i create a oracle jdbc provider and gave the jar files path. and then created ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: How to configure oracle datasource for the use of ejbs?

  1. How to configure oracle datasource for the use of ejbs?

    hai every body,
    i am trying to use oracle for my ejb project. i am able to connect to the database in the database perspective. i create a oracle jdbc provider and gave the jar files path. and then created datasource and gave the connection string and the databasename there then selected the authentication which i created in the security tab of the server configuration. and i can see the ejbs in the universal test client. but whern i try to call create method of the home interface i am getting an error saying

    Error trace at console
    -----------------------

    Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/oracleds, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a PooledConnection from the DataSource.
    at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterEx ception.(DataStoreAdapterException.java:251)
    at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterEx ception.(DataStoreAdapterException.java:172)
    at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAd apterException(AdapterUtil.java:182)
    at com.ibm.ws.rsadapter.DSConfigurationHelper.getPool edConnection(DSConfigurationHelper.java:663)
    at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooled Connection(WSRdbDataSource.java:189)
    at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.createManagedConnection(WSManagedConnectionF actoryImpl.java:503)
    at com.ibm.ejs.j2c.poolmanager.FreePool.createManaged ConnectionWithMCWrapper(FreePool.java:1106)
    at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitF orConnection(FreePool.java:897)
    at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(Po olManager.java:1065)
    at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrappe r(ConnectionManager.java:560)
    at com.ibm.ejs.j2c.ConnectionManager.allocateConnecti on(ConnectionManager.java:374)
    at com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImp l.getConnection(WSRdbConnectionFactoryImpl.java:21 7)
    at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.get Connection(WSRelationalRAAdapter.java:472)
    at com.ibm.ws.ejbpersistence.cache.TransactionListene rImpl.getConnection(TransactionListenerImpl.java:2 23)
    at com.ibm.ws.ejbpersistence.dataaccess.DataAccessReq uestImpl.execute(DataAccessRequestImpl.java:70)



    Error trace at universal test client
    ------------------------------------

    com.ibm.ejs.container.CreateFailureException: javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.ResourceAdapterEx ception: PMGR6020E: Error connecting to adapter com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImp l@a97e881; nested exception is: javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.ResourceAdapterEx ception: PMGR6020E: Error connecting to adapter com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImp l@a97e881 javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.ResourceAdapterEx ception: PMGR6020E: Error connecting to adapter com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImp l@a97e881 com.ibm.ws.ejbpersistence.utilpm.ResourceAdapterEx ception: PMGR6020E: Error connecting to adapter com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImp l@a97e881 at com.ibm.ws.ejbpersistence.dataaccess.DataAccessReq uestImpl.execute(DataAccessRequestImpl.java:73) at com.ibm.ws.ejbpersistence.beanextensions.CBStatefu lPersistor.executeCreate(CBStatefulPersistor.java: 229) at com.ibm.ws.ejbpersistence.beanextensions.CBNotExis tState.ejbCreate(CBNotExistState.java:38) at com.ibm.ws.ejbpersistence.beanextensions.CBStatefu lPersistor.ejbPostCreate(CBStatefulPersistor.java: 94) at com.ibm.ws.ejbpersistence.beanextensions.ConcreteB eanStatefulInstanceExtensionImpl.ejbPostCreate(Con creteBeanStatefulInstanceExtensionImpl.java:133) at entity.ConcreteCMP4_5d56c312.ejbPostCreate(Concret eCMP4_5d56c312.java:183) at entity.EJSCMPCMP4HomeBean_5d56c312.create_Local(EJ SCMPCMP4HomeBean_5d56c312.java:82) at entity.EJSLocalCMPCMP4Home_5d56c312.create(EJSLoca lCMPCMP4Home_5d56c312.java:34) at java.lang.reflect.Method.invoke(Native Method) at com.ibm.etools.utc.model.ReflectionMethodModel.inv oke(ReflectionMethodModel.java:68) at com.ibm.etools.utc.servlet.InvokeServlet.invoke(In vokeServlet.java:110) at com.ibm.etools.utc.servlet.InvokeServlet.doPost(In vokeServlet.java:323)

    can any body trace out the problem and help me.
    Rahul

  2. Re: How to configure oracle datasource for the use of ejbs?

    i have created the data source sucessfully. i had to download the new oracle thin driver and use that driver. Remember to use the same driver for datasource and the connection. i gave the old jar to connect to oracle it worked there so i didnt doubt that. but at last i found that and used the new driver for datasource and connection. Also should create an authentication under security tab in the test server.


+ Reply to Thread