From Talend Administration Center, you can
access the H2 administration console.
For more information about H2 use and troubleshooting, refer to the H2 online
documentation on http://www.h2database.com.
Procedure
-
From the main Menu, click Configuration to access the Configuration page.
-
On the Configuration page, expand the Database node to display the parameters.
-
In the Web Console field, click the link to
access the H2 Web Console.
-
The H2 Web Console's Login page
displays:
-
In the User Name and Password fields, type in the connection login and password
to the database, by default tisadmin and
tisadmin.
-
The JDBC URL field reads by default:
jdbc:h2:/<ApplicationPath>/WEB-INF/database/talend_administrator;AUTO_SERVER=TRUE;MVCC=TRUE;LOCK_TIMEOUT=15000
where <ApplicationPath>
is the location
where org.talend.administrator was deployed.
Warning: If you have moved the H2 embedded database
location, then fill out the JDBC URL field with the
updated URL information. Prior to clicking Connect,
click the Test Connection button in order to check
the new URL. In case of a mistyped URL, the JDBC URL
will revert back to the original URL information.
-
Click Connect.
Results
The Web database administration page displays.