To allow other users to access the H2 database for centralized storage of cross-project information, do the following:
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>
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:
Open the configuration.properties file in the <ApplicationPath>/WEB-INF/Classes folder, and edit the H2 database URL setting as follows:
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.
Now others can access and use the H2 database through the URL address.