H2 configuration

To connect to the H2 database use the following configuration:

With a local Blueriq installation, use the following JDBC URLS in the H2 console:

• For the aggregate data: jdbc:h2:C:\Program Files\Blueriq14\Services\customerdata\conf\customerdata-sql-store;AUTO_SERVER=TRUE 
  (depending on the location of the Blueriq install)
• For the case data: jdbc:h2:mem:testdb

For security reasons, the H2 Console is disabled by default (since Blueriq 11.5). You can enable it by adding a property to application-development-tools.properties. See Development tools component.

Usage

By default an H2 database  will be used for out-of-the-box persistency. Please note that H2 is a simple file-based database that is not suitable for production environments.

The database has a web based user interface that is integrated in the Blueriq dashboard: