Configuring the H2 database

To use the H2 database, you must update the Bootstrap.properties file with the correct credentials to connect to the H2 database. Ensure that you encrypt the password.

About this task

For example, here is typical H2 database content from a Bootstrap.properties file.

curam.db.type=h2
curam.db.name=curamdb
curam.db.username=curam
curam.db.password=qqnscP4c4+s=
# H2 directory.
# Default is home directory
# (i.e. C:/Documents and Settings/<username>). (Optional)
curam.db.h2.directory=C:/H2
# Mode remote|embedded
curam.db.h2.mode=embedded
# For remote mode also specify:
curam.db.serverport=9092
curam.db.servername=localhost
# Lock Time Out in ms. Default is 1000, i.e. 1 second. (Optional)
curam.db.h2.locktimeout=20000
# Property to disable MVCC. Default: true. (Optional)
curam.db.h2.mvcc=true

After you update the Bootstrap.properties file and rebuild the server and database, you can develop in the same way as you would with Oracle or DB2.

For more information about the Bootstrap.properties file, see the Cúram Server Developers Guide.

Procedure

  1. Edit the Bootstrap.properties file.
  2. Ensure that each of the database properties has the correct values for the H2 database.