In my application, I am querying multiple SQL Servers to return some data.
In my main function, I am iterating through the SQL Servers and on each of
them, I am iterating through the queries that are supposed to run to fetch
the data. When querying the SQL Server for data, I am using a connection
promise returned by the following function.
function poolIt (sqlQuery,sqlServer,databaseName) {
if(!connection)
{
//sqlServer_temp = sqlServer
//instead of checking if connection is defined
//we have to check if connection is open
var dbConfiguration = {
driver: 'msnodesqlv8',
server: sqlServer,
database: databaseName,
options: {
trustedConnection: true
}
}
connection = sql.connect(dbConfiguration);
}
}
Now when the loop is done for one SQL Server, it should connect to another
SQL Server. But when the debug mode is on, I see that all the queries are
running against only one server. I understand that this is because of the
above function as it is checking if a connection object is available or not
before creating a new connection. So, my question is on how to kill the
connection object? connection.close() is not working and nor does
sql.close()
Any help, please ?
--
Job board: http://jobs.nodejs.org/
New group rules:
https://gist.github.com/othiym23/9886289#file-moderation-policy-md
Old group rules:
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
---
You received this message because you are subscribed to the Google Groups
"nodejs" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/nodejs/44521f9c-993a-4e4f-a533-efaba1d7054c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
