Node.js mssql错误:乏味的弃用"config.options.enableArithAbort&q

Question

我得到下面的错误。我该如何修复它？

乏味的弃用在"乏味"的下一个主要版本中，"config.options.enableArithAbort"的默认值将从"false"更改为"true"。显式地将值设置为"true"或"false"以使此消息静音。node_modules\mssql\lib\deopley\connection pool.js:61:23

Answer 1

将数据库配置选项更改为以下选项：

var config = {
user: 'username',
password: 'password',
server: 'localhost', 
database: 'databasename',
"options": {
"encrypt": true,
"enableArithAbort": true
}
};

请在此处阅读问题详细信息：https://github.com/tediousjs/node-mssql/issues/976

Answer 2

以下对我有效：

const config = {
user: 'sa',
password: '<YOUR_PASSWORD>',
server: '<COMPUTER_NAME>\SQLEXPRESS',
database: '<DBNAME>',
requestTimeout: 180000, // for timeout setting
connectionTimeout: 180000, // for timeout setting
"options": {
"encrypt": false, // need to stop ssl checking in case of local db
"enableArithAbort": true
}
}

Answer 3

根据繁琐的文档和设置arithaport-

enableArithAbort: true // Ends a query when an overflow or divide-by-zero error occurs during query execution.  
encrypt: true, // A boolean determining whether or not the connection will be encrypted. Set to true if you're on Windows Azure.

Answer 4

不要在项目中的config中设置，而是在node_modules中设置值node_modules/sequalize/lib/方言/mssql/connection-manager.js.

options: {
enableArithAbort: true,//<----------set this to true
port: parseInt(config.port, 10),
database: config.database,
trustServerCertificate: true
}