Slow queries or even fake freezes when getting a database connection via Hibernate session.connection ()

In applications that use Hibernate, if you need to use Java.sql.Connection directly, we usually get through Hibernate's Session.connection (), and then Session.close (), But connection does not need close.

After a period of operation, the query will be slow, as if the crash. The reason is that when querying, the session cannot get connections from the connection pool.

Because the connection has reached the configured maximum value.

Workaround: After connection is used, call the Session.disconnection () method to put the connection back into the connection pool.

Slow queries or even fake freezes when getting a database connection via Hibernate session.connection ()