Warning |
---|
Has HSQLDB been superceded by PostGreSQL? if yes, should we delete this page? HL. |
Warning |
---|
I am not entirely happy with the stop and start scripts and also not done picking apart the example provided by hsqldb and explaning the reasoning behind our own custom script. |
Introduction
Warning |
---|
Explain what HSQLDB is about. |
Setup
Warning |
---|
To fill in, though it's pretty simple. |
Starting
If the admin password has changed, the /opt/hsqldb/sqltool.rc must be edited.
...
Code Block | ||
---|---|---|
| ||
# Make an environment variable called CLASSPATH export CLASSPATH # Set CLASSPATH to include the hsqldb.jar file. Java will look at CLASSPATH list to know what to execute. CLASSPATH=/path/to/hsqldb/lib/hsqldb.jar # Executes Java program calling class and sends to background. nohup java org.hsqldb.Server & |
Stopping
Script,
Code Block | ||
---|---|---|
| ||
cd /opt/hsqldb java -jar lib/hsqldb.jar --sql "shutdown;" --rcFile ./sqltool.rc localhost-sa |
versus HSQLDB manual.
Backup
Warning |
---|
Start from really simple, using tar, to using script and then advanced using replication. |
Adding Users
There is a need to have multiple users for administration of the HSQL database.
...
Code Block | ||
---|---|---|
| ||
CREATE USER sheeley password "<password>" GRANT SELECT ON APP_COMM TO sheeley; GRANT INSERT ON APP_COMM TO sheeley; GRANT UPDATE ON APP_COMM TO sheeley; GRANT SELECT ON BUNDLE TO sheeley; GRANT INSERT ON BUNDLE TO sheeley; GRANT UPDATE ON BUNDLE TO sheeley; GRANT SELECT ON RESOURCE TO sheeley; GRANT INSERT ON RESOURCE TO sheeley; GRANT UPDATE ON RESOURCE TO sheeley; |
Changing Password
The syntax command for changing the password
...
The password encryption tool is in source control C:\SVN\tools\gtb-encryption\encryption.bat
Resources
http://hsqldb.org/doc/2.0/guide/unix-chapt.html - start here and simplify these instructions.