Snippets
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
| 5172 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]
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers