org.h2.jdbc.JdbcSQLException: Database is already closed (to disable automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-176]

GitHub | WimVerhaert | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    IllegalArgumentException

    GitHub | 9 months ago | WimVerhaert
    org.h2.jdbc.JdbcSQLException: Database is already closed (to disable automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-176]

    Root Cause Analysis

    1. org.h2.jdbc.JdbcSQLException

      Database is already closed (to disable automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-176]

      at org.h2.message.DbException.getJdbcSQLException()
    2. H2 Database Engine
      JdbcResultSet.getMetaData
      1. org.h2.message.DbException.getJdbcSQLException(DbException.java:344)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      2. org.h2.message.DbException.get(DbException.java:178)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      3. org.h2.message.DbException.get(DbException.java:154)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      4. org.h2.message.DbException.get(DbException.java:143)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      5. org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1468)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      6. org.h2.jdbc.JdbcStatement.checkClosed(JdbcStatement.java:987)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      7. org.h2.jdbc.JdbcPreparedStatement.checkClosed(JdbcPreparedStatement.java:1621)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      8. org.h2.jdbc.JdbcStatement.checkClosed(JdbcStatement.java:961)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      9. org.h2.jdbc.JdbcResultSet.checkClosed(JdbcResultSet.java:3179)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      10. org.h2.jdbc.JdbcResultSet.getMetaData(JdbcResultSet.java:143)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      10 frames
    3. ORMLite JDBC
      JdbcCompiledStatement.runQuery
      1. com.j256.ormlite.jdbc.JdbcDatabaseResults.<init>(JdbcDatabaseResults.java:32)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      2. com.j256.ormlite.jdbc.JdbcCompiledStatement.runQuery(JdbcCompiledStatement.java:55)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      2 frames
    4. ORMLite Core
      Where.query
      1. com.j256.ormlite.stmt.SelectIterator.<init>(SelectIterator.java:55)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      2. com.j256.ormlite.stmt.StatementExecutor.buildIterator(StatementExecutor.java:247)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      3. com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:196)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      4. com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:265)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      5. com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:361)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      6. com.j256.ormlite.stmt.Where.query(Where.java:503)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      6 frames
    5. org.mycontroller.standalone
      MetricsAggregationJob.doRun
      1. org.mycontroller.standalone.db.dao.MetricsDoubleTypeDeviceDaoImpl.getAggregationRequiredVariableIds(MetricsDoubleTypeDeviceDaoImpl.java:128)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      2. org.mycontroller.standalone.metrics.MetricsAggregationBase.aggregateForBucketSensorVariable(MetricsAggregationBase.java:56)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      3. org.mycontroller.standalone.metrics.MetricsAggregationBase.executeBucketByBucket(MetricsAggregationBase.java:220)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      4. org.mycontroller.standalone.metrics.MetricsAggregationBase.runAggregation(MetricsAggregationBase.java:312)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      5. org.mycontroller.standalone.metrics.jobs.MetricsAggregationJob.doRun(MetricsAggregationJob.java:35)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      5 frames
    6. org.knowm.sundial
      Job.execute
      1. org.knowm.sundial.Job.execute(Job.java:57)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      1 frame
    7. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:178)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      2. org.quartz.core.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:515)[mycontroller-dist-standalone-0.0.3.Alpha2-SNAPSHOT-single.jar:0.0.3.Alpha2-SNAPSHOT]
      2 frames