RA Banner Agent does not start after changing database password

Document ID : KB000109831
Last Modified Date : 07/08/2018
Show Technical Document Details
Issue:
After changing the password for the Banner database user Banworx, the RA Banner Agent fails with the following error in the logs:

20180801/163427.842 - U02000107 Connection object 'CONN.NAME' with time stamp '1533155624000' was successfully transferred to the Agent. 
20180801/163443.282 - Database login error 
20180801/163443.282 - Error connecting to the database. Check the JDBC login assigned to the agent and verify that it is correct. 

A forced stack trace is created with the error: 

java.sql.SqlRecoverableException: IO error: Connection reset
 
Cause:
Either the connection object passwords have not been changed, or the password is cached in the jdbc. 
Resolution:
Ensure that the passwords are changed in the connection objects. If this has already been done, then load a fresh JDBC following the steps below:

-Stop the RA Banner Agent
-Navigate to the Agent's bin/lib directory
-Copy the jdbc jar file to another folder as a backup
-Download the relevant .jar file for the database being used
-Delete the old file and replace it with the new jdbc jar file
-Restart the Agent