I'm evaluating HikariCP to use with our product, but have run into one odd issue.
Sometimes we run using HSQLDB in standalone mode.
This means that when our app is going to exit, it runs the sql statement "Shutdown Compact".
Then when the connection is closed we get this in our log.
WARN | Metrix_0 - Connection org.hsqldb.jdbc.JDBCConnection@349a9ba0 marked as broken because of SQLSTATE(08503), ErrorCode(-1353)
java.sql.SQLNonTransientConnectionException: connection exception: closed
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
What should I do to prevent this?