Loading
Write a code in such a way that my SQL connection should be always connected?
2 Answers
var mysqltest = require('mysql');
var pool = mysqltest.createPool({
host : ‘host.org',
user : 'username',
password : 'password'
});
exports.getUsers = function(callback) {
pool.getConnection(function(err, connection) {
if(err) {
console.log(err);
callback(true);
return;
}
var sqlQuery = "SELECT id,name FROM users";
connection.query(sqlQuery, [], function(err, results) {
connection.release(); // always put connection back in pool after last query
if(err) {
console.log(err);
callback(true);
return;
}
callback(false, results);
});
});
});
Sanjit Kumar SinghPosted May 5, 2018, 1:03 AM
connection.ConnectionTimeout=0;
Setting timeout value as 0 will change defialt timeout to infinite.
Rahul ChavanPosted Apr 7, 2016, 10:33 PM