Setting up the H2 database for access from other machines

To allow other users to access the H2 database for centralized storage of cross-project information, you need to start the H2 server and edit the database URL to make Talend Administration Center work.

Starting the H2 server

Procedure

Stop Tomcat service if it is running.
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.
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.

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

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

Results

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

Configuring the H2 database URL

You need to edit the database URL to make Talend Administration Center work.

Procedure

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.
Start the Tomcat service.
Start your Talend Administration Center Web application.

Results

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here