After an upgrade or after new database calls are configured for an self-managed installation, calls to the database from the application server fail and the following error is seen in the application server log:
ERROR org.hibernate.transaction.JDBCTransaction - Could not toggle autocommit java.sql.SQLException: Connection has already been closed.
The database connection has been abandoned since the query ran for more than the allotted time configured in removeAbandonedTimeOut (the default value is 60s).
removeAbandonedTimeOut
Increase the value of removeAbandonedTimeOut in tomcat-resources.xml so that it is set to the longest running query the application may have.
This article applies to Appian 19.1 and later.
Last Reviewed: August 2020