Starting the H2 Web Console

Start the H2 Web Console by running the org.h2.tools.Server class in h2.jar as follows:

java -cp %CuramSDEJ%\drivers\h2.jar org.h2.tools.Server -tcp -web

Use this updated command for 6.0.5.6 Fix Pack and later versions:

java -cp %CuramSDEJ%\drivers\h2-1.3.176.jar org.h2.tools.Server -tcp -web

You can access the H2 Web Console at the following URL:

http://localhost:8082/

The JDBC connection URL that you specify in the login screen is based on the curam.db.name, curam.db.username, and curam.db.h2.directory values in Bootstrap.properties. These values define the database name, SCHEMA name, and the database location in the file system. So, if your database name is curamdb, your user name is curam and curam.db.h2.directory defaults to your home directory, then your JDBC string would look like this example:

jdbc:h2:tcp://localhost/~/curamdb;schema=curam;FILE_LOCK=SOCKET

For example, if the curam.db.h2.directory is C:/H2, then your JDBC string would look like this example:

jdbc:h2:tcp://localhost/file:C:/H2/curamdb;schema=curam;FILE_LOCK=SOCKET

Specify the values for User Name and Password as in your Bootstrap.properties file and then click the Connect button (or Test Connect button). When connected, a SQL text control is available.