Error conection database mysql log

Camunda 7 Topics Discussion & Questions
,
3

Configure these properties testOnBorrow , validationQuery and validationInterval.

DB_VALIDATE_ON_BORROW  = true
transaction-isolation = READ-COMMITTED

Refer these settings:

<Resource name="jdbc/ProcessEngine"
          auth="Container"
          type="javax.sql.DataSource"
          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
          uniqueResourceName="process-engine"
          driverClassName="com.mysql.jdbc.Driver"
          url="jdbc:mysql://XXXX:3306/camunda?autoReconnect=true"
          username="XXXX"
          password="XXXX"
          maxActive="20"
          minIdle="10" 
		  testWhileIdle="true"
		  testOnBorrow="true"
		  testOnReturn="false"
		  validationQuery="SELECT 1"
		  validationInterval="30000"
		  timeBetweenEvictionRunsMillis="30000"
		  maxWait="10000"
		  removeAbandonedTimeout="60"
		  removeAbandoned="true"
		  logAbandoned="true"
		  minEvictableIdleTimeMillis="30000"
		  connectionTimeout="300000"
		  jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;
				org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;
				org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer" />

https://github.com/camunda/docker-camunda-bpm-platform/issues/125