You are currently reviewing an older revision of this page.
After an upgrade or after new database calls are configured for an on-premise 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
t
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