How to release connection which is used by hikari?

Question

Spring

The method has a request for an external resource that can take a long time to complete. Before that, there is work with the database and hikari transfers the connection to the active state until the method ends. How can we release the connection before we send a request to an external resource?

Answer 1

I think the solution to the issue will be to use the hikari connection pool (HikariCP) with several connections.

Answer 2

It is necessary to take out work with the database in a separate DAO layer. And now let all sorts of services use Tao-classes. Then the connection will open just enough to get data from the database.