I am using Hikari connection pool manager to query some tables in an AS400 machine.
I've set a minimum of 1 connection pool connections and a maximum of 10. I am querying 5 tables at the same time.
The problem is that despite using HikariDataSource getConnection() method before querying and using Connection close() method after each query, when I go to WRKACTJOB I see 10 active jobs, presumably one per connection until max connection pool connections are reached.
How do I get clear the unused connections\jobs?