public static void main(String[] arg) {
boolean webserver;
String driver = "org.hsqldb.jdbcDriver";
String url;
String user;
String password;
int port;
String defaulturl;
String shutdownarg;
if (arg.length > 0) {
String p = arg[0];
if ((p != null) && p.startsWith("-?")) {
printHelp();
return;
}
}
HsqlProperties props = HsqlProperties.argArrayToProps(arg, "server");
webserver = props.isPropertyTrue("server.webserver", false);
defaulturl = webserver ? "jdbc:hsqldb:http://localhost" : "jdbc:hsqldb:hsql://localhost";
int defaultport = webserver ? 80 : 9001;
port = props.getIntegerProperty("server.port", defaultport);
url = props.getProperty("server.url", defaulturl + ":" + port);
user = props.getProperty("server.user", "sa");
password = props.getProperty("server.password", "");
shutdownarg = props.getProperty("server.shutdownarg", "");
try {
Class.forName(driver); // Load the driver
Connection connection = DriverManager.getConnection(url, user, password);
Statement statement = connection.createStatement();
// can use SHUTDOWN COMPACT or SHUTDOWN IMMEDIATELY
statement.execute("SHUTDOWN " + shutdownarg);
} catch (ClassNotFoundException cnfe) {
System.err.println(cnfe); // Driver not found
} catch (SQLException sqle) {
System.err.println(sqle); // error connection to database
}
}
