Skip to main content Skip to complementary content

Administrating the H2 database through the Web console

To help you administrate the H2 embedded database, a dedicated Web console is available directly from Talend Administration Center.

Connecting to the H2 Web Console

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

  1. From the main Menu, click Configuration to access the Configuration page.
  2. On the Configuration page, expand the Database node to display the parameters.
    The following parameters display: URL, user, password, driver, and web console.
  3. In the Web Console field, click the link to access the H2 Web Console.
  4. The H2 Web Console's Login page displays:
  5. In the User Name and Password fields, type in the connection login and password to the database, by default tisadmin and tisadmin.
  6. 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.
    Information noteWarning: 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.
  7. Click Connect.

Results

The Web database administration page displays.

Backing up the H2 database

The configuration parameters of the H2 database backup is already set by default so that the backup occurs on an daily basis.

About this task

If you need or want to make edits to this setting, edit the configuration file:

<ApplicationPath>/WEB-INF/classes/configuration.properties

The cron-based backup of the embedded database triggers everyday at 3.45 am all year round. The syntax reads as follows "Seconds Minutes Hours Day-of-month Month Day-of-week Year", such as for example:
  • 0 45 3 ? * * * (default setting, trigger every day at 3.45 am)
  • 0 45 5 ? * MON-FRI (every Monday, Tuesday, Wednesday, Thursday, and Friday at 5.45 am)

More examples are available in the Quartz Tutorial's lesson on ConTrigger.

Other automatic backups are performed at startup and shutdown of the application server:

database.embedded.backup.doBackupAtStartup=true
database.embedded.backup.doBackupAtShutdown=true

The backup files are stored at the following location, up to the 30 latest backups:

<ApplicationPath>/WEB-INF/database/backups

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