Error :Caused by: java.sql.SQLException: ORA-28001: the password has expired

Reason: This error means your database password is expired.

  1. Reset the database password and the same password needs to configured in OpenSpecimen. Follow the below steps to do this.
  2. Shut down the Tomcat service
  3. Modify the password in $TOMCAT_HOME/conf/context.xml file

    Context.xml file
    <Resource name="jdbc/openspecimen" auth="Container" type="javax.sql.DataSource"
          maxActive="100" maxIdle="30" maxWait="10000"
          username="<db_user_name>" password="<new_db_password>" driverClassName="<DRIVER_CLASS_NAME>"
          url="<DB_URL>" />
  4. Start the Tomcat service