connectionDetails

This setting is deprecated starting in Profound.js 5.0.0. Use the databaseConnections property instead.

This configuration option is not valid for the "IBMi" driver in versions prior to 4.9.0.

Specifies the database connection details.

When the "mysql", the "mssql", or the "oracledb" database driver is used, the connection details must match the connection config format of the database driver's corresponding NPM package:

When the "IBMi" driver is used the connection details must match the attribute names/values documented in the DB2/i SQL Call Level Interface.

Examples:

Basic MySQL configuration

dbDriver: "mysql",
connectionDetails: {
  user: 'testuser',
  password: 'testpwd',
  server: 'localhost',
  database: 'testdb'
}

**DB2/i - Disable commitment control and set date format to *EUR**

dbDriver: "IBMi",
connectionDetails: {
  "SQL_ATTR_COMMIT": "SQL_TXN_NO_COMMIT",
  "SQL_ATTR_DATE_FMT": "SQL_FMT_EUR"
}

Click here for information on how to modify this setting.