Hi, from v7.9 through v7.11 (ce) we do experience problems reconnecting to sqlserver after a intermediate loss of connection. The only solution seems to be restarting Tomcat.
Problem occurs regardless of driver (it seems) including mssql-jdbc-7.2.2.jre11.jar, and on several installations (so should not be a instance problem).
To reproduce:
Run camunda towards a sqlserver database.
Stop sqlserver instance and trigger any action to cause loss of connection
Start sqlserver instance and try to log in
Is there a way of avoiding this except monitoring and restarting Tomcat?
Subset of log:
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/User.xml
### The error may involve org.camunda.bpm.engine.impl.persistence.entity.UserEntity.selectUserCountByQueryCriteria
### The error occurred while executing a query
### Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectOne(DbSqlSession.java:117)
org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectOne(DbEntityManager.java:189)