Skip to content

Instantly share code, notes, and snippets.

@kdabir
Created February 23, 2012 07:38
Show Gist options
  • Save kdabir/1891338 to your computer and use it in GitHub Desktop.
Save kdabir/1891338 to your computer and use it in GitHub Desktop.
Windows cmd script to run HSQLDB server and client GUI
@echo off
REM set these variables
SET HSQLDB_HOME=c:\path\to\hsqldb
SET DB_NAME=mydb
REM start the server in new window ( prompt visible, so that you can CTRL+C )
REM database files are created in current directory/data
start java -cp %HSQLDB_HOME%\lib\hsqldb.jar org.hsqldb.server.Server --database.0 file:data/%DB_NAME% --dbname.0 %DB_NAME%
REM start the client GUI and connect to server ( no new cmd window opens because of javaw )
start javaw -cp %HSQLDB_HOME%\lib\hsqldb.jar org.hsqldb.util.DatabaseManagerSwing --url jdbc:hsqldb:hsql://localhost/%DB_NAME%
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment