JDBC Properties

Description

JDBC properties to pass to the JDBC driver when establishing a connection.

For example to supply a property property1 with the value value1, you can set migratedb.jdbcProperties.key1=value1 . MigrateDB will then set the key1 property on the jdbc driver to value1 when it establishes a connection.

Usage

This configuration parameter will only be used in the command line version of MigrateDB.

Command line

./migratedb -jdbcProperties.accessToken=my-access-token info

Configuration File

migratedb.jdbcProperties.accessToken=my-access-token

Environment Variable

MIGRATEDB_JDBC_PROPERTIES_accessToken=access-token

Use Cases

Passing access tokens

Some database JDBC drivers support authentication with access tokens, but this token may not be supported in the URL ( see SQL Server Azure Active Directory). You may also not want to leak information such as tokens in the URL. In these cases, an additional properties object can be passed to the JDBC driver which can be configured with jdbcProperties allowing you to achieve, for example, authentication that wasn’t previously possible.