db.h2

This type connects to a H2 database.

Get more information at https://www.h2database.com.

Use cases

• Connect to database
• Use a H2 database for storing data locally
• Share data across local installation using H2’s server mode

Parameters

1: host

host: "host name"

• define the host name of the server where the database file is located
• this parameter is optional and only relevant when connecting in server mode

2: port

port: "port number"

• define the port number for connecting to the host
• this parameter is optional and only relevant when connecting in server mode

3: path

path: "path"

• define the file path where the database file is stored

4: file

file: "file"

• define the file name of the database file

5: user

user: "user name"

• define the user name to use for the establishing the connection

6: password

password: "user password"

• define the user password to use for establishing the connection

Examples

---
type: Connection
data:
  name: "db.h2.1"
  type: "db.h2"
  description: "db.h2 connection"
  environment: "iesi-test"
  parameters:
  - name: "host"
    value: ""
  - name: "port"
    value: ""
  - name: "path"
    value: "#iesi.home#/data/iesi-test/fwk/data/connections"
  - name: "file"
    value: "db.h2.1"
  - name: "user"
    value: ""
  - name: "password"
    value: ""