Setting up the H2 database for access from other machines - 6.4

Talend MDM Platform Installation Guide for Windows

EnrichVersion
6.4
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
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 Management
Talend Installer
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Project Audit
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

To allow other users to access the H2 database for centralized storage of cross-project information, do the following:

  1. Stop Tomcat service if it is running.

  2. Unzip your H2 database server package to any of your local drives. The latest H2 database server package is available at http://www.h2database.com/html/download.html.

  3. Open a CMD window, navigate to the drive where the H2 database server package was unzipped, and change directory to h2\bin, which contains the h2*.jar file.

  4. Start the H2 server as a service using the following command:

    java -cp h2*.jar org.h2.tools.Server -tcp -tcpAllowOthers
    -tcpPort <port_number>

Now other users can access the H2 database, but you still need to edit the database URL to make Talend Administration Center work.

To do so, proceed as follows:

  1. Open the configuration.properties file in the <ApplicationPath>/WEB-INF/Classes folder, and edit the H2 database URL setting as follows:

    database.url=jdbc:h2:tcp://<IP_address>:<port_number>/file:<ApplicationPath>/WEB-INF/database/talend_administrator;AUTO_SERVER=TRUE;IFEXISTS=TRUE;MVCC=TRUE; LOCK_TIMEOUT=15000

    where <IP_address> is your IP address, <port_number> is the TCP port number specified in the command used to start the H2 server, and <ApplicationPath> is the location where org.talend.administrator was deployed.

  2. Start the Tomcat service.

  3. Start your Talend Administration Center Web application.

Now others can access and use the H2 database through the URL address.