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.