You are currently reviewing an older revision of this page.
Calls to the database from app server fail after an upgrade or migration. 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.
This article applies to Appian 19.1 and later.
Last Reviewed: June 2020