Setting up HSQL as a Windows service for the portal - 7.3

Talend Installation Guide
Version
7.3
Language
English
Operating system
Windows
Subscription type
Subscription
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend LogServer
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
Last publication date
2022-10-30
Deprecated
Available in...

Big Data Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

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