CMP bean2.0 doesn't work upon restart

[Mala Sharma]

Hello,
I'm having a weird problem with my CMP bean. When i test it on WSAD5.1 test server, it works.But if i restart the server and try to test the bean again, it gives me following exception. Does anyone know why it works if i don't restart the server but doesn't upon restarting. Following is the exception. Thanks

 javax.ejb.EJBException:  ; nested exception is: javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.ResourceAdapterException: PMGR6020E: Error connecting to adapter com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl@46203c48
javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.ResourceAdapterException: PMGR6020E: Error connecting to adapter com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl@46203c48
com.ibm.ws.ejbpersistence.utilpm.ResourceAdapterException: PMGR6020E: Error connecting to adapter com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl@46203c48
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeCreate(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbPostCreate(Unknown Source)
at com.tutorial.ejb.ConcreteTestEmployee_ccb1e334.ejbPostCreate(ConcreteTestEmployee_ccb1e334.java:145)
at com.tutorial.ejb.EJSCMPTestEmployeeHomeBean_ccb1e334.create_Local(EJSCMPTestEmployeeHomeBean_ccb1e334.java:71)
at com.tutorial.ejb.EJSLocalCMPTestEmployeeHome_ccb1e334.create(EJSLocalCMPTestEmployeeHome_ccb1e334.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
at java.lang.reflect.Method.invoke(Method.java:386)
at com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:366)
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:283)
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:974)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:443)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
Caused by: javax.resource.spi.ResourceAllocationException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: [IBM][CLI Driver] SQL1403N  The username and/or password supplied is incorrect.  SQLSTATE=08004
.
 

[Mala Sharma]

Ok, i think i know where my problem lies. Its not finding the datasource. But, if i run another web application which uses this datasource and connection pooling, i can see the results of that web applicaiton. And, if i run my CMP bean right after that web application, my bean seems to work fine with no exceptions. Man, this is really weird