WebSphere Start up

[Greg Bonk]

When I try to startup WebSphere 3.5.3, almost instantly I get the following error...
10/21/01 5:46 PM : WARNING [aixsys08/MuniTax]: WJTI0005W: Encountered an error while creating XA connection and XA resource COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0119E Unexpected system failure. SQLSTATE=58004
at COM.ibm.db2.jdbc.DB2Exception.<init>(DB2Exception.java:93)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:174)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.java:351)
at COM.ibm.db2.jdbc.app.DB2ReusableConnection.<init>(DB2ReusableConnection.java:66)
at COM.ibm.db2.jdbc.DB2PooledConnection.getConnection(DB2PooledConnection.java:183)
at COM.ibm.db2.jdbc.DB2XAConnection.<init>(DB2XAConnection.java:96)
at COM.ibm.db2.jdbc.DB2XADataSource.getXAConnection(DB2XADataSource.java:99)
at com.ibm.ejs.jts.jta.factory.DB2JTAXAResourceFactory.getXAResource(DB2JTAXAResourceFactory.java:79)
at com.ibm.ejs.jts.jta.JTSXA.recover(JTSXA.java(Compiled Code))
at com.ibm.ejs.jts.jta.recovery.XARecoveryManager.xaRestartRecovery(XARecoveryManager.java:225)
at com.ibm.ejs.jts.jta.recovery.XARecoveryManager.duringRestart(XARecoveryManager.java:210)
at com.ibm.ejs.jts.tran.Tran.ready(Tran.java:193)
at com.ibm.ejs.jts.jts.CurrentSet.ready(CurrentSet.java:159)
at com.ibm.ejs.jts.jts.Jts.ready(Jts.java:132)
at com.ibm.ejs.sm.server.ManagedServer.initializeTran(ManagedServer.java:937)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime(ManagedServer.java:574)
at com.ibm.ejs.sm.server.ManagedServer.main(ManagedServer.java:140)
10/21/01 5:46 PM : WARNING [aixsys08/MuniTax]: WJTI0025W: Can not create XAResource object
After doing some detailed trace logging it appears to be creating a connection pool with a now defunct user ID and password. There seems to be a need to recover some resources. Classes that are used include XARecUtil, JTSXA, TranRecoveryServ.
I don't know where it's getting this old data to try to create the connection pool. Does any one have an idea of where this old user ID and password is being stored and how I can remove it? I've tried to restart the server, but ofcourse it is persistant, and I've removed the data source and re added it.
- Greg

[Kyle Brown]

It sounds like it might be the datasource for the admin database that is old. If that's true you're nearly hosed, but not quite. Try doing a search of the properties files in the WebSphere install directories for the old username and/or password. If I remember right, I think that the admin userid and password were actually stored in plaintext, and thus you can change them in the properties file.
Kyle
------------------
Kyle Brown,
Author of Enterprise Java (tm) Programming with IBM Websphere
See my homepage at http://members.aol.com/kgb1001001 for other WebSphere information.

[Greg Bonk]

Let me clarify a little bit. I receive the error when I start up a Web Application from with in the WebSphere Administrator Console.
I'll try to scan any files that might have the user ID and password in it.
I don't understand how or why this was set. Was it set when we used a new Data source for the first time? Why would WebSphere want to hold onto user IDs and passwords when they potentially could change and not have an obvious place to reset them?