Using the H2 Web Console

If the H2 web console is enabled it may be reached using a web browser on its configured port.

To Use the H2 Web Console

  1. In a modern web browser, navigate to the host and port configured for the web console.

    The console will appear similar to the following when viewed for the first time:

    media/image1.jpeg

  2. Copy the following values to this form from the application.yml configuration file in the same directory as the software’s JAR file and supporting scripts:

    • datasource.url to JDBC URL

    • datasource.password to Password

      Note: Leave User Name as sa.

      media/image2.jpeg

  3. Click Connect.

    The console will update to appear similar to the following:

    media/image3.jpeg

    Note: EVENT_HISTORY and JOB_DETAILS tables will only appear if the software has used this database at least once in job and event load processing.

  4. From this display SQL statements may be executed and other operations performed on the database, per web console documentation:

    http://www.h2database.com/html/tutorial.html#console_synta