You are viewing the documentation for Blueriq 13. Documentation for other versions is available in our documentation directory.

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\Blueriq 11\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:

  • No labels