DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Fyodor has posted 14 posts at DZone. View Full User Profile

Scriptella Script To Shutdown HSQLDB Server

12.20.2006
| 5733 views |
  • submit to reddit
        The following snippet performs shutdown of HSQLDB database.

<!DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd">
<etl>
    <connection driver="hsqldb" url="jdbc:hsqldb:hsql://127.0.0.1/mydb" user="sa" classpath="hsqldb.jar"/>
    <script>
        SHUTDOWN;
    </script>
</etl>

Running Scriptella from Ant is simple:
<taskdef classpath="scriptella.jar" resource="antscriptella.properties" />
<etl file="file_path"/>

Command line launcher is even simpler:
scriptella [file_path]