Setting up the H2 database for access from other machines

Talend ESB Installation Guide for Solaris

EnrichVersion
6.3
EnrichProdName
Talend ESB
task
Installation and Upgrade

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.