Setting up HSQL as a Windows service for the portal

Talend Real-Time Big Data Platform Installation Guide for Windows

EnrichVersion
6.5
EnrichProdName
Talend Real-Time Big Data Platform
task
Installation and Upgrade
EnrichPlatform
Talend Runtime
Talend Administration Center
Talend Installer
Talend CommandLine
Talend Artifact Repository
Talend Activity Monitoring Console
Talend Data Stewardship
Talend JobServer
Talend Studio
Talend Identity and Access Management
Talend DQ Portal
Talend ESB
Talend Log Server
Talend Data Preparation
Talend SAP RFC Server
Talend Repository Manager

Procedure

  1. Follow the procedures about JobServer using JSL to install a Windows Service as outlined in Installing Talend JobServer as a service.
  2. Open the jsl_static64.ini file to edit it.
    Note: The jsl_static64.ini file may not exists in the JSL directory. In that case, copy the jsl.ini file and rename it as follows: jsl_static64.ini.
  3. Modify the following area(s) in the file to fit your environment:
    [service]
    appname = HSQLService
    servicename = HSQLService
    displayname = HSQLService
    [java]
    params = 7
    param00 = -cp
    param01 = <PathToJar>\hsqldb1_8_0_2.jar
    param02 = org.hsqldb.Server
    param03 = -database.0
    param04 = <PathToDatabase>\tdqportal
    param05 = -dbname.0
    param06 = tdqportal