Hi,
I am trying to deploy and run a CMP 2.0 on WSAD 5.0 using cloudscape as a database. I am getting the following error. Could someone please give me a step to step guide to doing this. I am at odds as to what to do next.
[11/25/03 18:20:29:456 GMT+05:30] ba31d3c WSRdbDataSour E DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: No suitable driver.
[11/25/03 18:20:29:487 GMT+05:30] ba31d3c WSRdbDataSour E DSRA0010E: SQL State = 08001, Error Code = 0
[11/25/03 18:20:29:503 GMT+05:30] ba31d3c WSRdbDataSour E DSRA0011E: Exception: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:266)
at com.ibm.db2j.jdbc.DB2jDataSource.findDriver(Unknown Source)
at com.ibm.db2j.jdbc.DB2jDataSource.getConnectionViaDriver(Unknown Source)
at com.ibm.db2j.jdbc.DB2jDataSource.getConnection(Unknown Source)
at com.ibm.db2j.jdbc.DB2jPooledConnection.getConnection(Unknown Source)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getConnection(WSRdbDataSource.java:204)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:498)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:964)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:772)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1049)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:507)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:328)
at com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl.getConnection(WSRdbConnectionFactoryImpl.java:217)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.getConnection(WSRelationalRAAdapter.java:471)
at com.ibm.ws.ejbpersistence.cache.TransactionListenerImpl.getConnection(TransactionListenerImpl.java:231)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:63)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.executeCreate(CBStatefulPersistor.java:192)
at com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(CBNotExistState.java:32)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.ejbPostCreate(CBStatefulPersistor.java:85)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbPostCreate(ConcreteBeanStatefulInstanceExtensionImpl.java:135)
at lucky.ConcreteLuckyBean.ejbPostCreate(ConcreteLuckyBean.java:173)
at lucky.EJSCMPLuckyBean_LuckyHome_87b881bbBean.create(EJSCMPLuckyBean_LuckyHome_87b881bbBean.java:50)
at lucky.EJSRemoteCMPLuckyBean_LuckyHome_87b881bb.create(EJSRemoteCMPLuckyBean_LuckyHome_87b881bb.java:100)
at lucky._EJSRemoteCMPLuckyBean_LuckyHome_87b881bb_Stub.create(_EJSRemoteCMPLuckyBean_LuckyHome_87b881bb_Stub.java:241)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:108)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:314)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:825)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:443)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:171)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:66)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:430)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:546)
[11/25/03 18:20:29:690 GMT+05:30] ba31d3c StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode 0 and SQLState 08001, to a StaleConnectionException: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:266)
at com.ibm.db2j.jdbc.DB2jDataSource.findDriver(Unknown Source)
at com.ibm.db2j.jdbc.DB2jDataSource.getConnectionViaDriver(Unknown Source)
at com.ibm.db2j.jdbc.DB2jDataSource.getConnection(Unknown Source)
at com.ibm.db2j.jdbc.DB2jPooledConnection.getConnection(Unknown Source)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getConnection(WSRdbDataSource.java:204)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:498)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:964)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:772)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1049)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:507)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:328)
at com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl.getConnection(WSRdbConnectionFactoryImpl.java:217)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.getConnection(WSRelationalRAAdapter.java:471)
at com.ibm.ws.ejbpersistence.cache.TransactionListenerImpl.getConnection(TransactionListenerImpl.java:231)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:63)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.executeCreate(CBStatefulPersistor.java:192)
at com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(CBNotExistState.java:32)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.ejbPostCreate(CBStatefulPersistor.java:85)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbPostCreate(ConcreteBeanStatefulInstanceExtensionImpl.java:135)
at lucky.ConcreteLuckyBean.ejbPostCreate(ConcreteLuckyBean.java:173)
at lucky.EJSCMPLuckyBean_LuckyHome_87b881bbBean.create(EJSCMPLuckyBean_LuckyHome_87b881bbBean.java:50)
at lucky.EJSRemoteCMPLuckyBean_LuckyHome_87b881bb.create(EJSRemoteCMPLuckyBean_LuckyHome_87b881bb.java:100)
at lucky._EJSRemoteCMPLuckyBean_LuckyHome_87b881bb_Stub.create(_EJSRemoteCMPLuckyBean_LuckyHome_87b881bb_Stub.java:241)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:108)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:314)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:825)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:443)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:171)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:66)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:430)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:546)
[11/25/03 18:20:30:987 GMT+05:30] ba31d3c FreePool E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/LuckyDS, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: No suitable driver.
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.setLinkedException(DataStoreAdapterException.java:373)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:444)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.translateSQLException(WSRdbDataSource.java:389)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getConnection(WSRdbDataSource.java:218)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:498)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:964)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:772)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1049)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:507)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:328)
at com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl.getConnection(WSRdbConnectionFactoryImpl.java:217)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.getConnection(WSRelationalRAAdapter.java:471)
at com.ibm.ws.ejbpersistence.cache.TransactionListenerImpl.getConnection(TransactionListenerImpl.java:231)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:63)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.executeCreate(CBStatefulPersistor.java:192)
at com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(CBNotExistState.java:32)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.ejbPostCreate(CBStatefulPersistor.java:85)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbPostCreate(ConcreteBeanStatefulInstanceExtensionImpl.java:135)
at lucky.ConcreteLuckyBean.ejbPostCreate(ConcreteLuckyBean.java:173)
at lucky.EJSCMPLuckyBean_LuckyHome_87b881bbBean.create(EJSCMPLuckyBean_LuckyHome_87b881bbBean.java:50)
at lucky.EJSRemoteCMPLuckyBean_LuckyHome_87b881bb.create(EJSRemoteCMPLuckyBean_LuckyHome_87b881bb.java:100)
at lucky._EJSRemoteCMPLuckyBean_LuckyHome_87b881bb_Stub.create(_EJSRemoteCMPLuckyBean_LuckyHome_87b881bb_Stub.java:241)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:108)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:314)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:825)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:443)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:171)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:66)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:430)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:546)