HSQLDB Shutdown Compact when using Hikari

Skip to first unread message

John Lussmyer

Aug 2, 2019, 5:28:44 PM8/2/19
to HikariCP
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?

John Lussmyer

Aug 5, 2019, 11:57:47 AM8/5/19
to HikariCP
Since ConnectionPooling really isn't needed when using HSQLDB locally, I added a check in our code to just not use Hikari for that configuration.
Reply all
Reply to author
0 new messages