I am using azure mysql database for my camunda instance which is hosted on azure. Intermittently I am getting “Unable to acquire JDBC Connection” after I submit around 40-50 request to start a workflow. Error message as below. However, it works fine after sometime.
ENGINE-REST-HTTP500 org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
Did anyone face similar issue?Is there any fix for this?
Hi @rashmiagrl Welcome to the forum
Consider these points to solve this issue:
- Configure HikariCP or Tomcat-jdbc connection pool in the process application or jndi data source
- Hold maximum active connections at least
Thanks for the suggestion. I am currently using HikariCP connection pool and given max pool size as 20. But still getting the same error.
I suspect that this issue is not related to the Camunda Engine as the engine didn’t use hibernate.
Maybe it’s thrown in custom code? Have a look at the complete stack trace.
Hope this helps, Ingo
@rashmiagrl Which transaction manager are you using?