Having issues with a simple query that's failing with a RequestError: Invalid object name 'dbo.SomeTable'
Any idea why this would not find any tables?
SQL Management Studio testing shows the user credentials are correct and the account has access to the tables etc.
let sqlConfig = {
user: 'username',
password: 'password',
server: 'servers name or IP',
database: 'TestDB',
port: 1433,
options: {
database: 'TestDB',
"encrypt": true,
"enableArithAbort": true
}
};
let pool = await sql.connect(sqlConfig);
let result = await pool.request().query('SELECT * FROM [dbo].[SomeTable]');
How could I send a valid json?
When I am executing query in SQL Management Studio I see 2020-03-31 04:35:43 value for let's say timestamp column
However when I am executing the very same query from node-mssql with default driver I am receiving a Date with 2020-03-30 21:35:43 GMT-0700. Is it somehow possible to read Date value from DB without converting time to local(e.g. as is)?
Origin(DB value): 2020-03-31 04:35:43.410
useUTC: true(default) => Date: Mon Mar 30 2020 21:35:43 GMT-0700 (Mountain Standard Time)
if I call toDBString on the resulting value => '2020-03-31 04:35:43'
useUTC: false => Date: Tue Mar 31 2020 04:35:43 GMT-0700 (Mountain Standard Time)
if I call toDBString on the resulting value => '2020-03-31 11:35:43'
So it would be an application concern to know what timezone the server is in, and correct accordingly.
const currentTimestamp = new Date(Date.UTC(
now.getFullYear(),
now.getMonth(),
now.getDate(),
now.getHours(),
now.getMinutes(),
now.getSeconds()
));const now = new Date();
Just to be sure am I able to read Date value from DB as string without converting to local? In such a case i would send this value to moment-timezone America/New-York and this would produce me est date as is?
Hey everyone! I would like to get a little help.... I am trying to wrap my head around the connection pools, but I am a bit confused...
So i Have an "SQLConnector.js" file, which looks like this
const sql = require('mssql');
const sqlConnector = () => {
config = {
user: "xxxxx",
password: "xxxx",
server: "localhost",
database: "Test",
options: {
trustServerCertificate: true
}const pool = new sql.ConnectionPool(config);
return poolConnect = pool.connect();
}
module.exports = {
sqlConnector,
sql
}
In another file "writeToDb1.js" i am calling the exported sqlConnector module like this:
const pool = await sqlConnector.sqlConnector();
await pool.request().query(query)Everything works like a dream... but I do not get this pool management... If i create a new file 'writeToDb2.js' with the above mentioned code... will that create another pool?
As I understood from the documentation, once a pool has been created, the connect() will resolve to that pool always... so i tried creating a file 'writeToDb3.js' with the following code:
const sql = require('mssql')
// run a query against the global connection pool
function runQuery(query) {
// sql.connect() will return the existing global pool if it exists or create a new one if it doesn't
return sql.connect().then((pool) => {
return pool.query(query)
})
}
But this one throws an error Cannot read property 'port' of undefined. I believe its because i did not provide the config file. This part is not clear also...I already created the pool above with the config file.... I thought i just have to call the connect() function.
Any help would be highly appreciated!
@flashp0wa:matrix.org With your current code everytime you call sqlConnector() you'll be creating a new pool. You're going to have a problem with this code because you're never closing the pools you create and will cause a connection limit error on your server like this, you'll also no doubt have created memory leaks within your application layer. If you want to have a persistent pool you would need a variable you assign the pool to and return that if it is assigned, eg:
let pool;
const getPool = () => {
if (!pool) pool = new ConnectionPool(config).connect();
return pool;
}the reason that sql.connect() is not working is because you have created a pool yourself , then you've attempted to access a global pool (managed by the library code) that you have not configured or instantiated yet
Hey Everybody!
I have here a function called streamRead(). In this function i have defined the logic to read values from the database which has two event 'request.on('row', callback) and request.on('done', callback). Looking like this:
function streamRead {
let rowsToProcess = [];
request.on('row', row => {
rowsToProcess.push(row);
if (rowsToProcess.length >= 15) {
request.pause();
processRows();
}
});
request.on('done', () => {
let iNeedThisValueReturned = processRows();
});
console.log('This runs immediately after calling request.on('done',...), without waiting the function inside (processRows()) to finish. This is sad because i need the value returned from processRows()');
return iNeedThisValueReturned; //this is a promise actually containing the resolve with the value i need
}So the problem is decribed in the console.log. If i call streamRead from somewhere else in the code. I get no return object. Like this:
async function aFunctionInAnotherFile {
let valueReturnedFromStreamRead = await asd.streamRead();
console.log(valueReturnedFromStreamRead) // This is empty because reques.on('done') is still running and 'return iNeedThisValueReturned' has been returned immidiately after reques.on('done') has been called. resulting in an empty object. Also console.log() is immediately running after the await function. Like the await is not working
}I dont know if the problem that the 'await' not working in 'aFunctionInAnotherFile()' or I just have to let JS know to wait for on.request('done') to finish.
The main problem just to reiterate... the whole code finished running while the function in the reques.on('done') is still counting it's stuff
Anybody has any idea what I am missing... cant wrap my head around it for 2 days now. I hope i was able to represent in an understandable fashion. If not please dont hesitate to request clarification, i am trying my best :)
Thank a lot in advance!
Okey, so the answer was to include in the code once(request, 'done'). Also it makes no sense to wait for the callbackfuntion, since that is not even fired (the streamRead still working on the 'row' events... meaning the query is still read working and reading data from the database.). This way i can wait for the 'done' event finish before returning to the caller.
So the solution looks like this:
function streamRead {
const { once } = require('events');
let rowsToProcess = [];
request.on('row', row => {
rowsToProcess.push(row);
if (rowsToProcess.length >= 15) {
request.pause();
processRows();
}
});
request.on('done', () => {
let iNeedThisValueReturned = processRows();
});
await once(request,'done');
return iNeedThisValueReturned; //this is a promise actually containing the resolve with the value i need
}:point_up: Edit: Okey, so the answer was to include in the code once(request, 'done'). Also it makes no sense to wait for the callbackfuntion, since that is not even fired (the streamRead still working on the 'row' events... meaning the query is still read working and reading data from the database.). This way i can wait for the 'done' event finish before returning to the caller.
So the solution looks like this:
function streamRead {
const { once } = require('events');
let rowsToProcess = [];
request.on('row', row => {
rowsToProcess.push(row);
if (rowsToProcess.length >= 15) {
request.pause();
processRows();
}
});
request.on('done', () => {
let iNeedThisValueReturned = processRows();
});
await once(request,'done');
return iNeedThisValueReturned;
}
dhensby on master
Update changelog for v5 Merge pull request #796 from dh… (compare)