Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com
Error :Caused by: java.sql.SQLException: ORA-28001: the password has expired
Reason: This error means your database password is expired.
Reset the database password and the same password needs to configured in OpenSpecimen. Follow the below steps to do this.
Shut down the Tomcat service
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>" />Start the Tomcat service