4 Replies Latest reply on Feb 8, 2012 9:13 AM by smarlow

JdbcSQLException: "Database is already closed" on server shutdown

jhuska Feb 8, 2012 8:56 AM

Hi,

I am having the same problem as described at AS7-2045. The workaround is described there as well, however it is need to change default DS on AS and therefore this can not be shipped with our application, which is using this DS, but every user has to change it accordingly.

I have also found some other ways to workaround it, but with a little bit different functionality, and it is to use create hibernate.hbm2ddl.auto instead of create-drop, which seems OK for me as it is only showcase application. Am I correct ?

There was also proposed one solution, and I am asking whether this will be fixed in some next releases or we should use another approach ?

1. Re: JdbcSQLException: "Database is already closed" on server shutdown

jesper.pedersen Feb 8, 2012 8:59 AM (in response to jhuska)

H2 isn't a supported database and shouldn't be used on your Openshift account. If you want to use it find a configuration that works for you.
Actions
2. Re: JdbcSQLException: "Database is already closed" on server shutdown

jhuska Feb 8, 2012 9:07 AM (in response to jesper.pedersen)

Sorry, but I forget to mention that for me it is not related with Openshift very much. My issue is described here. I just use the original issue, because there is better described what is wrong.
But I guess that answer will be very similar, that we should use something else than default DS and set it properly with workaround, since this one will not be fixed/supported soon?
Actions
3. Re: JdbcSQLException: "Database is already closed" on server shutdown

jesper.pedersen Feb 8, 2012 9:10 AM (in response to jhuska)

There is no default datasource -- JBoss Application Server 7 includes a datasource that can be used for examples called "ExampleDS", but it is in no way supported.

Yes, so you should create your own setup using the database and the configuration of your choice.

See the JBoss Enterprise Application Platform documentation for databases that are supported with a subscription.
1 of 1 people found this helpful
Actions
4. Re: JdbcSQLException: "Database is already closed" on server shutdown

smarlow Feb 8, 2012 9:13 AM (in response to jhuska)

Juraj,

I wonder if anyone has looked at contributing a H2 patch to make it easier to disable the shutdown hook. Or perhaps a better way to control H2 when its embedded. Let us know what you find.

Scott
Actions

Go to original post