We occasionaly hit org.apache.tomcat.jdbc.pool.PoolExhaustedException when threads are holding connections for too long or are going into a deadlock state.
Any recomendation to tweak in Tomcat's DB Connection Configuration or Data source Factory Configuration ?
2023-04-16 20:46:20,104 ERROR Exception occurred 36032 org.apache.tomcat.jdbc.pool.PoolExhaustedException: [https-jsse-nio] Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available [size:200; busy:200; idle:0; lastwait:30000] .36033 at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:738)
We tried changing removeAbandoned = true, testOnBorrow = true, testOnReturn = true but we still run into the problem. Anything further to check ?