]
Jiří Štefek updated RF-13498:
-----------------------------
Fix Version/s: 4.5.0.Alpha3
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
Assignee: Juraj Húska
Priority: Trivial
Labels: 45x, photoalbum
Fix For: 4.5.0.Alpha3, 5.0.0.Alpha3
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.