Skip to content

Instantly share code, notes, and snippets.

@tisseurdetoile

tisseurdetoile/hsqldb.cmd

Forked from kdabir/hsqldb.cmd
Created May 31, 2018 13:11
Show Gist options
  • Save tisseurdetoile/c35a2e486f301be2b482a0d3e69cbde2 to your computer and use it in GitHub Desktop.
Save tisseurdetoile/c35a2e486f301be2b482a0d3e69cbde2 to your computer and use it in GitHub Desktop.
Download ZIP
Windows cmd script to run HSQLDB server and client GUI
Raw
hsqldb.cmd
@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