Groovy MY-NOTEBOOK

Saturday, January 14, 2012

HSQLDB server how to run

個人的には手軽なので Groovy SQL と組み合わせて使う RDBMS が HSQLDB です。

テスト用

This is groovy version hsqldb server.

@Grab(group='org.hsqldb', module='hsqldb', version='2.0.0')

def dbName = 'mydb'
def dbPath = "file:${dbName}"

def myargs = ['--database.0',dbPath,'--dbname.0',dbName] as String[]
org.hsqldb.server.Server.main( myargs )

dbPath ... you can also specify dbPath as absolutePath like this ...

def dbPath = "file:/var/hsqldb/${dbName}"

Of course, your current *unix-user has rw access right in /var/hsqldb/db-name dir.

実運用

1. Download hsqldb-version.zip from http://hsqldb.org/
2. Install hsqldb-version.zip $HOME/opt/hsqldb
3. And run below shell-script

#!/bin/sh

dbhome=$HOME/opt/hsqldb
mydb=$dbhome/mydb
java -Xms12m -Xmx24m  -cp $dbhome/lib/hsqldb.jar org.hsqldb.server.Server --database.0 file:$mydb --dbname.0 mydb > /dev/null 2>&1 &

• dbPath is $HOME/opt/hsqldb
• db-name is mydb