Spring Boot monitor JDBC Pool activities

Question

I'm facing with a frustrating problem with jdbc

org.apache.tomcat.jdbc.pool.PoolExhaustedException: [...] Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:4; busy:4; idle:0; lastwait:30000]

I found several solutions here about how to fix it but this is not the point.

I'd like to see from the logs WHO is creating these connections and not releasing.

Do you know some spring boot configuration or logback setup to show the event where a jdbc connection is taken from or returned to the pool?

Thanks

Answer 1

If following Paul's recommendation doesn't help, my next step would be to add:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-actuator</artifactId>
</dependency>

Then use the /trace and /metrics endpoints to figure out whats happening.