I am using.
Spring-Boot: (v2.6.6)
Camunda BPM: (v7.12.0)
Camunda BPM Spring Boot Starter: (v3.4.0)
When I deploy then following error is coming
Could not open JDBC Connection for transaction; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available
As per camunda threads I have added following properties as well but still same issue
spring.datasource.hikari.connection-timeout=200000
spring.datasource.hikari.minimum-idle=10
spring.datasource.hikari.maximum-pool-size=50
spring.datasource.hikari.idle-timeout=600000
spring.datasource.hikari.max-lifetime=1800000
spring.datasource.leak-detection-threshold= 450000
logging.level.com.zaxxer.hikari.pool.HikariPool=DEBUG
spring.datasource.testWhileIdle=true
spring.datasource.test-on-borrow=true
if I deploy older version of camunda 7.9 on one server and 7.12 version on another server, pointing both servers to same db in which 7.12 schema’s are present then both works without any issue, no connection issue.
But alone if I run 7.12 version with same db then connection issue comes.
Is there something in db tables.
Require help to resolve this issue.
Thanks
Prash