What are the possible cases where a SQL Too many connections issue can occur while using HikariCP in Spring Boot and Hibernate

Asked Mar 26 '20 at 19:16

Active Mar 26 '20 at 20:41

Viewed 200 times

0

java.sql.SQLNonTransientConnectionException: Too many connections

Facing this issue very frequently. Can anyone please please help

edited Mar 26 '20 at 19:38

jarlh

42,561
8
45
63

asked Mar 26 '20 at 19:16

Bashayam

1

Does this answer your question? [HikariCP too many connections](https://stackoverflow.com/questions/27505536/hikaricp-too-many-connections) – Issam El-atif Mar 26 '20 at 21:42

1 Answers1

0

It looks like your database complains that you hold too many connections open, consume even more but don't close them again.
If you have the default connection pool settings of Hikari (which you should have and not specify i.e. a poolSize of 1000), this problem should basically not happen.

answered Mar 26 '20 at 20:41

Marco Behler

3,627
2
17
19