How to set up HSQL Db as a Windows Service

Overview

This article describes how to install HSQL for the DQ Portal as a Windows Service.

 

Environment

All supported Windows versions.

 

Symptoms/Description

There is no built-in mechanism for installing HSQL Db as a Windows Service.

 

Resolution

Follow the installation guide for Job Server using JSL to install a Windows Service (Installing JobServer as a service) and modify the following area(s) in the jsl_static.ini or jsl_static64.ini file to fit your environment:

 

[service]
appname = HSQLService
servicename = HSQLService
displayname = HSQLService
[java]
params = 9
param00 = -cp
param01 = <PathToJar>\hsqldb.jar (set this parameter to <PathToJar>\hsqldb1_8_0_2.jar if you use the 5.6.3 release or older)
param02 = org.hsqldb.Server
param03 = -database.0
param04 = <PathToDatabase>\tdqportal
param05 = -dbname.0
param06 = tdqportal
param07 = -port
param08 = 7890 ( set this parameter to 9001 if you use the 5.3.2 release or older)

 

Related Files

jsl_static64.ini, in attached zip file

Version history
Revision #:
10 of 10
Last update:
‎05-15-2017 11:36 PM
Updated by:
 
Labels (1)
Contributors
Tags (1)