[jboss-jira] [JBoss JIRA] (AS7-2045) JdbcSQLException: "Database is already closed" on server shutdown

[Juraj Huska (JIRA)]

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

Juraj Huska reopened AS7-2045:
------------------------------

      Assignee:     (was: Jozef Hartinger)


I am experiencing the same issue with RichFaces showcase application. I have described my problems in RF-11905.

The workaround proposed here works, however without it it does not. The closing issue here indicates that it was fixed and should work without workaround, is it so ? 
                
> JdbcSQLException: "Database is already closed" on server shutdown
> -----------------------------------------------------------------
>
>                 Key: AS7-2045
>                 URL: https://issues.jboss.org/browse/AS7-2045
>             Project: Application Server 7
>          Issue Type: Bug
>          Components: JCA, JPA / Hibernate
>    Affects Versions: 7.0.2.Final
>            Reporter: Jozef Hartinger
>            Priority: Critical
>             Fix For: 7.1.0.Beta1
>
>         Attachments: standalone-persistent.xml, test.war
>
>
> An application that uses the "create-drop" Hibernate ddl strategy fails do undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown log below.
> This issue is critical for the demo applications on *openshift express* (which uses persistent setup for the built-in database) where redeploy is expected to get the application to the default state.
> To reproduce:
> # Use the attached standalone-persistent.xml profile (the only change is redefinition of the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
> # Deploy the attached application
> # Start the server with the persistent profile (./standalone.sh --server-config=../standalone/configuration/standalone-persistent.xml)
> # Stop the server (Ctrl+C)
> # You should see the exception below
> {noformat}
> 16:42:43,982 INFO  [org.jboss.as.logging] Restored bootstrap log handlers
> 16:42:44,003 INFO  [org.jboss.jpa] stopping Persistence Unit Service 'test.war#booking' 
> 16:42:44,005 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl schema export
> 16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231: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-145]
>         at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
>         at org.h2.message.DbException.get(DbException.java:167)
>         at org.h2.message.DbException.get(DbException.java:144)
>         at org.h2.message.DbException.get(DbException.java:133)
>         at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
>         at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
>         at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
>         at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
>         at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
>         at org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
>         at org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
>         at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
>         at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
>         at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
>         at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
>         at org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
>         at org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88) [jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
>         at org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909) [jboss-msc-1.0.1.GA.jar:1.0.1.GA]
>         at org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872) [jboss-msc-1.0.1.GA.jar:1.0.1.GA]
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_24]
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_24]
>         at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
> 16:42:44,018 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export complete
> 16:42:44,022 INFO  [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying TransactionManagerService
> 16:42:44,028 INFO  [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery manager
> 16:42:44,030 INFO  [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
> 16:42:44,032 INFO  [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
> {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira