Hikari pool gets exhausted

[marinsimina]

1. I was getting Hikari pool exhausted. it turned out I was opening a new connection after calling g.tx().close().

2. How can I configure the hikari pool, if necessary? I am using the following in application.yaml to configure sqlg:

sqlg:
  dataSource:
    jdbc.url: ${url}
    jdbc.username: ${username}
    jdbc.password: ${password}

Thanks!

[pietermartin]

You must not call g.tx().close().
Always only call g.tx().commit() or g.tx().rollback(). It is important to always commit or rollback on the transaction else you will end up with idle in transaction connections on the database.