WebSphere 5.0 to DB2 complains of wrong USERID/PASSWORD
hazli
username and/or password is supplied wrongly" when the application
hits the DB2 database.
The DB2 is configured correctly with the USERNAME and PASSWORD. The
J2C Authentication Data is also configured to reflect the same
USERNAME and PASSWORD.
The Stack trace is as below. Would appreciate if somebody could shed a
little light on this. Thank you.
==Hazli
----------- Stack trace start----------------------------------------
[7/9/03 12:48:49:641 GMT-08:00] 49f36793 FreePool E J2CA0046E:
Method createManagedConnctionWithMCWrapper caught an exception during
creation of the ManagedConnection for resource jdbc/tradeds, throwing
ResourceAllocationException. Original exception:
com.ibm.ws.exception.WsException: 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
.
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:251)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:172)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:125)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.translateSQLException(WSRdbDataSource.java:397)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getConnection(WSRdbDataSource.java:227)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:504)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1106)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:897)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1065)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:560)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:374)
at com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl.getConnection(WSRdbConnectionFactoryImpl.java:217)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.getConnection(WSRelationalRAAdapter.java:472)
at com.ibm.ws.ejbpersistence.cache.TransactionListenerImpl.getConnection(TransactionListenerImpl.java:223)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.executeOneRowFBPK(DataAccessRequestImpl.java:246)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.fetchRecordFromDataStore(ConcreteBeanStatefulInstanceExtensionImpl.java:262)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.getRecordForLoad(ConcreteBeanStatefulInstanceExtensionImpl.java:216)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.executeLoad(CBStatefulPersistor.java:281)
at com.ibm.ws.ejbpersistence.beanextensions.CBReadyState.ejbLoad(CBReadyState.java:29)
at com.ibm.ws.ejbpersistence.beanextensions.CBStatefulPersistor.ejbLoad(CBStatefulPersistor.java:116)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbLoad(ConcreteBeanStatefulInstanceExtensionImpl.java:148)
at com.ibm.trade.ConcreteProfile_4fbe7412.ejbLoad(ConcreteProfile_4fbe7412.java:71)
at com.ibm.ejs.container.ContainerManaged2_0BeanO.loadForEnlist(ContainerManaged2_0BeanO.java:319)
at com.ibm.ejs.container.EntityBeanO.enlist(EntityBeanO.java:700)
at com.ibm.ejs.container.activator.OptCEntityActivationStrategy.atActivate(OptCEntityActivationStrategy.java:118)
at com.ibm.ejs.container.activator.Activator.activateBean(Activator.java:518)
at com.ibm.ejs.container.EJSHome.activateBean_Common(EJSHome.java:1216)
at com.ibm.ejs.container.EJSHome.activateBean_Local(EJSHome.java:1130)
at com.ibm.trade.EJSCMPProfileHomeBean_4fbe7412.findByPrimaryKey_Local(EJSCMPProfileHomeBean_4fbe7412.java:25)
at com.ibm.trade.EJSLocalCMPProfileHome_4fbe7412.findByPrimaryKey(EJSLocalCMPProfileHome_4fbe7412.java:58)
at com.ibm.trade.bo.QueryAccountBO.getAccountInfo(QueryAccountBO.java:52)
at com.ibm.trade.TradeFacadeBean.getAccountInfo(TradeFacadeBean.java:139)
at com.ibm.trade.EJSLocalStatelessTradeFacade_216250fb.getAccountInfo(EJSLocalStatelessTradeFacade_216250fb.java:27)
at com.ibm.trade.model.AccountModel.getAccountInfo(AccountModel.java:68)
at com.ibm.trade.servlets.AccountInfoServlet.doPost(AccountInfoServlet.java:57)
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:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
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:71)
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:432)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)
----------- Stack trace end ----------------------------------------