It's nothing to worry about unless you start seeing hundreds of connections
const pool2 = new sql.ConnectionPool(config, err => {
// ... error checks
}).connect();
// ... error checks
}).connect();
I get an error saying already connecting
also connect() returns promise which gives error on the next line
pool2.on('error', err => {
// ... error handler
})
// ... error handler
})
Either omit the callback and use the promise, or embrace callback hell
_g[conn].request().query(preparedQuery, function (err, records) {
_g[conn].on('error', errdb => {
reject(_t.i(1005, configurations.errors, errdb));
Logger.log("error", "tmsmssql", "SYS", _t.i(1005, configurations.errors, errdb));
return;
});
if (err) {
reject(_t.i(1003, configurations.errors, JSON.stringify(err)));
} else {
if (records.rowsAffected[0] > 0) {
if (op === 'INSERT' || op === 'UPDATE' || op === 'DELETE') {
resolve(_t.i(200, null, records));
} else {
resolve(_t.i(200, null, records.recordset));
}
} else {
reject(_t.i(1004, configurations.errors));
}
}
});
_g[conn].on('error', errdb => {
reject(_t.i(1005, configurations.errors, errdb));
Logger.log("error", "tmsmssql", "SYS", _t.i(1005, configurations.errors, errdb));
return;
});
if (err) {
reject(_t.i(1003, configurations.errors, JSON.stringify(err)));
} else {
if (records.rowsAffected[0] > 0) {
if (op === 'INSERT' || op === 'UPDATE' || op === 'DELETE') {
resolve(_t.i(200, null, records));
} else {
resolve(_t.i(200, null, records.recordset));
}
} else {
reject(_t.i(1004, configurations.errors));
}
}
});
I have a problem with the tutorial. I tried the ConnectionPool and always got the message that .on() is not a function and then I commented that out and tried it without, but now I get the error Already connecting to database. What did I do wrong?
const mssql = require('mssql');
let config = {...}; // that one is correct, I tested it with a pure simple query
const sqlPool = new mssql.ConnectionPool(config, err => {
console.log(err);
}).connect();
sqlPool.on('error', err => {
log(err);
});
const sqlQuery = queryString => {
return sqlPool.then(pool => {
pool.request().query(queryString)
}).then(result => {
console.dir(result);
})
};
sqlQuery("SELECT * FROM users");
const mssql = require('mssql');
let config = {...}; // that one is correct, I tested it with a pure simple query
const sqlPool = new mssql.ConnectionPool(config, err => {
console.log(err);
}).connect();
sqlPool.on('error', err => {
log(err);
});
const sqlQuery = queryString => {
return sqlPool.then(pool => {
pool.request().query(queryString)
}).then(result => {
console.dir(result);
})
};
sqlQuery("SELECT * FROM users");
Instead of this
mssql.ConnectionPool(config, err => {
console.log(err);
Try like this:
mssql.ConnectionPool(config)
.then((result) => {})
.catch((reason) => {});
Error handling is in the catch
.catch((reason) => {
console.error(reason);
});
grrrr... no I get the error: TypeError: (intermediate value).then is not a function
maybe I need a complete functioning module to adjust to my needs instead of small code samples. Do you have an example that I could use? I search for one that uses one connection for a long time (there maybe many calls to the same database from the same server without any other connections. So 1 connection that stays open for a longer time should be fine). The samples I found and that work all use a single call on a connection inside the connection call. But that way the connection would have to be closed and reopened on every query.
maybe I need a complete functioning module to adjust to my needs instead of small code samples. Do you have an example that I could use? I search for one that uses one connection for a long time (there maybe many calls to the same database from the same server without any other connections. So 1 connection that stays open for a longer time should be fine). The samples I found and that work all use a single call on a connection inside the connection call. But that way the connection would have to be closed and reopened on every query.
I think I know what you mean, personally I created a class that is technically a singleton for each database. Basically the connectionPool is module variable that calling modules access to. Then anytime I want to run requests I listen to the (already happened) on(“connect”) event
I've tried a connection string like this: Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=Northwind.sdf;Persist Security Info=False;
And get the following error: ConnectionError: Failed to connect to Northwind.sdf:1433 - getaddrinfo ENOTFOUND Northwind.sdf
Any help would be greatly appreciated
In the tables
Ty for ur hielo
Help
As @dhensby is one of the main maintainers, he may have a better idea
Thank u
function generateUpsertQueryString(myListOfObjects: MyDbTableRow[]) {
return myListOfObjects.map(o => `
-- update existing row if possible
UPDATE dbo.MyDbTable
SET SomeCol1 = '${o.someCol1}',
SomeCol2 = '${o.someCol1}'
WHERE SomeCol3 = '${o.someCol1}';
-- otherwise insert new row
IF @@ROWCOUNT = 0
INSERT INTO dbo.MyDbTable
(
SomeCol1,
SomeCol2,
SomeCol3
)
VALUES
(
'${o.someCol1}',
'${o.someCol2}',
'${o.someCol3}'
);
`).join('\n')
}mssql's "params" feature to escape strings. In the case above, the function is basically generating a giant query string. I pass the function a list of objects which should be used to update/insert rows into a table. So the function loops thru and generates an "upsert" statement for each item in the list. I foresee sql injection with this approach of using javascript template strings. Otherwise it seems I'd have to come up with a clever way to format all this data into the "params" object. Any ideas/recommendations?
dhensby on master
Update changelog for v5 Merge pull request #796 from dh… (compare)