title: Springboot JPA Repository not releasing Hikari DB Connection
body: <p>I have a rest API in Springboot using Hikari for connection pooling. Hikari is used with default configurations (10 connections in the pool, 30 sec timeout waiting for a connection). The API itself is very simple</p>
  <ol>
  <li>It first makes a JPA repository query to fetch some data from a PostgresDB. This part takes about 15-20milliseconds.</li>
  <li>It then sends this data to a remote REST API that is slow and can take upwards of 120seconds.</li>
  <li>Once the remote API responds, my API returns the result back to the client. A simplified version is shown below.</li>
  </ol>
  <pre class="lang-java prettyprint-override"><code>    public ResponseEntity analyseData(int companyId) {
          Company company = companyRepository.findById(companyId);//takes 20ms
          Analysis analysis = callRemoteRestAPI(company.data) //takes 120seconds
         return ResponseEntity.status(200).body(analysis);
  
      }
  </code></pre>
  <p>The code does not have any @Transactional annotations. I find that the JDBC connection is held for the entire duration of my API (i.e ~ 120s). And hence if we get more than 10 requests they timeout waiting on the hikari connection pool (30s).  But strictly speaking my API does not need the connection after the JPA query is done (Step 1 above).</p>
  <p>Is there a way to get spring to release this connection immediately after the query instead of holding it till the entire API finishes processing ? Can Spring be configured to get a connection for every JPA request ? That way if I have multiple JPA queries interspersed with very slow operations the server throughput is not affected and it can handle more than 10 concurrent API requests. .</p>