Uploaded image for project: 'RichFaces'
  1. RichFaces
  2. RF-13498

Photoalbum - shutting down server with deployed app will throw JdbcSQLException:

    Details

      Description

      Shutting down AS with deployed photoalbum.war will result in throwing following exception:

      15:40:12,568 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH000231: Schema export unsuccessful: 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-161]
      	at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
      	at org.h2.message.DbException.get(DbException.java:169)
      	at org.h2.message.DbException.get(DbException.java:146)
      	at org.h2.message.DbException.get(DbException.java:135)
      	at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1394)
      	at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1369)
      	at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:407)
      	at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:817)
      	at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1589)
      	at org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:298)
      	at org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
      	at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:368)
      	at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:319)
      	at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:315)
      	at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1279)
      	at org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:140)
      	at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.stop(PersistenceUnitServiceImpl.java:98) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]
      	at org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1911) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
      	at org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1874) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_05]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_05]
      	at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_05]
      

      As suggested by the exception message, it can be easily fixed by adding ;DB_CLOSE_ON_EXIT=FALSE to the connection url.

      This issue is similar to the RF-12102, which was resolved with same fix.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jhuska Juraj Húska
                Reporter:
                jhuska Juraj Húska
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: