[richfaces-issues] [JBoss JIRA] (RF-13498) Photoalbum - shutting down server with deployed app will throw JdbcSQLException:

[Juraj Húska (JIRA)]

Juraj Húska created RF-13498:
--------------------------------

             Summary: Photoalbum - shutting down server with deployed app will throw JdbcSQLException:
                 Key: RF-13498
                 URL: https://issues.jboss.org/browse/RF-13498
             Project: RichFaces
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: examples
    Affects Versions: 5.0.0.Alpha2
         Environment: JBoss AS 7.1.1.Final
            Reporter: Juraj Húska
            Priority: Trivial


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

{code}
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]
{code}

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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira