HSQLDB shutdown

Umlauf · **Joined:** Thu Aug 28, 2003 7:23 pm **Posts:** 1

Is there a way to perform a SHUTDOWN command on HSQLDB?
I'm using Hibernate 2.0.3 and HSQLDB 1.7.1.

steve · **Posted:** Sat Aug 30, 2003 11:17 am

I don't know, as I don't use HSQLDB. But this is a Hibernate forum, the question is better directed to the HSQLDB forum/mailing-list.

max · **Posted:** Sat Aug 30, 2003 11:34 am

Umlauf wrote:

Is there a way to perform a SHUTDOWN command on HSQLDB?
I'm using Hibernate 2.0.3 and HSQLDB 1.7.1.

Can you do it with JDBC ? Then just get the connection from the session and do whatever you are used to do with it ,)

pcexplorer · **Posted:** Mon Sep 26, 2005 10:50 am

try this

session.connection().createStatement().execute("SHUTDOWN");

Moreover the URL of the database have to end by ;shutdown=true. Here is an example:

jdbc:hsqldb:file:data/localBD;shutdown=true