You are currently reviewing an older revision of this page.
Calls to the database from app server fail after an upgrade or migration for an on-premise installation. The following error can be seen in the application server log:
ERROR org.hibernate.transaction.JDBCTransaction - Could not toggle autocommit java.sql.SQLException: Connection has already been closed.
Databases have a default timeout period after which it terminates idle connections, causing app server to not be able to make calls to the database.
Increase the value of removeAbandonedTimeOut in the tomcat-resources.xml.
removeAbandonedTimeOut
This article applies to Appian 19.1 and later.
Last Reviewed: June 2020