Lon Parisi - 2021-07-27

I have been experiencing an issue with a connection being closed...or at least that's what I'm being told in the stack trace. It seems very random. In addition, when I check the connection directly if it is null or closed (boolean isclosed = conn.isClosed()) neither one is the case. I don't have any idea how to reproduce this because as discussed its very random. Could it be some sort of networking issue that puts the connection in an unstable state? Any help here would be greatly appreciated.

Below is the latest stack trace of the error.

... 9 more
at net.ucanaccess.jdbc.UcanaccessStatement.executeBatch(UcanaccessStatement.java:205)
at com.baml.marketdata.EarnHist.storeData(EarnHist.java:237)
at com.baml.marketdata.EarnHist.runData(EarnHist.java:66)
at com.baml.marketdata.DynClassRunner.runSODClasses(DynClassRunner.java:283)
at com.baml.marketdata.DynClassRunner.main(DynClassRunner.java:89)
Caused by: 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.JDBCPreparedStatement.executeBatch(Unknown Source)
at net.ucanaccess.jdbc.ExecuteUpdate.executeWrapped(ExecuteUpdate.java:61)
at net.ucanaccess.jdbc.AbstractExecute.executeBase(AbstractExecute.java:264)
at net.ucanaccess.jdbc.ExecuteUpdate.executeBatch(ExecuteUpdate.java:53)
at net.ucanaccess.jdbc.UcanaccessStatement.executeBatch(UcanaccessStatement.java:203)
... 4 more
Caused by: org.hsqldb.HsqlException: connection exception: closed
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 9 more