hikaricp - jOOQ Connection Pool Release Pattern with HikariDataSource -

is correct way release connection pool

hikaridatasource ds = ...; final connection sqlconn = ds.getconnection(); final dslcontext ctx = dsl.using(sqlconn, sqldialect.derby);   // jooq queries here        ds.evictconnection(sqlconn); 

just want make sure right connections not re-cycled if not call evictconnection

no, calling sqlconn.close() release connection pool.

when hikaricp, or pool, returns connection getconnection(), returning proxy object intercepts close() call , returns connection pool instead of closing it.

evictconnection() method used. method forcefully close connection database , evict connection pool.