How does Camunda handle database session failures? Does it have automatic retry or does it need to be restarted somehow?.
2 Likes
Hi,
The answer may depend on your application and deployment architecture. However if you use a deployment pattern based on an application server such as Tomcat or Wildfly etc, these application servers normally provide a database connection pool. Hence the engine will borrow and return a connection from and to the pool on demand.
The DB connection pool can usually be configured with parameters such as maximum connection time to live, discard on error and even test on borrow to ensure the connection is actually working before the engine gets access.
Engine configuration for a Tomcat installation can be found here [1]
Configuration of the commons connection pool used by Tomcat can be found here [2]
regards
Rob
[1] https://docs.camunda.org/manual/7.9/installation/full/tomcat/manual/#configure-a-jdbc-resource
[2] https://commons.apache.org/proper/commons-dbcp/configuration.html
1 Like