SQL Connection Properties

url (string, required)

The URL of the database server

Example: "mariadb://user:[email protected]:5432/dbname"

probeConnectionDelay (integer)

The number of milliseconds between checking the connection for connectivity

Default: 10000

logLevel (string, enum)

Configures the additional log level for the connection. If set to error (default), only errors are logged. If set to debug, additionally all SQL queries are logged.

This element must be one of the following enum values:

• error

• debug

Default: "error"

trustAllCertificates (boolean)

If true, all certificates will be accepted, regardless of whether they can be validated or not. Use this option if self-signed server certificates should be accepted, or if there are other reasons which prevent this client to validate the certificates.

Default: false

Examples: true, false

connectionStrategy (object)

If a connection attempt fails, retries will be performed with increasing delay (waiting time) in between. The following parameters control how these delays behave.

Properties of the connectionStrategy object:

initialDelay (integer)

Delay (waiting time) of the first connection retry (in milliseconds). For subsequent retries, the delay will be increased according to the parameter incrementFactor which has a default value of 2.

Default: 1000

Additional restrictions:

• Minimum: 1000

maxDelay (integer)

Maximum delay (waiting time) to wait until the next retry (in milliseconds). The delay (waiting time) for any subsequent connection retry will not be larger than this value. Must be strictly greater than initialDelay.

Default: 30000

incrementFactor (integer)

The factor used to increment initialDelay up to maxDelay. For example if initialDelay is set to 1000 and maxDelay to 5000 the values for the delay would be 1000, 2000, 4000, 5000.

Default: 2

Additional restrictions:

• Minimum: 2