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

[Jiří Štefek (JIRA)]

     [ https://issues.jboss.org/browse/RF-13498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jiří Štefek closed RF-13498.
----------------------------



Verified with Photoalbum 4.5, closing.

> 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.



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)