What's the most common real root cause of connection pool exhaustion?

Connections being held longer than necessary — most often from a slow, unindexed query or an overly broad transaction boundary (doing non-database work inside a @Transactional method) — rather than the pool simply being undersized for actual concurrent load. Increasing pool size without investigating why connections are held too long only treats the symptom.