Node js sql - Node program doesn't exit

Question

I am new to node js. I know about event loop that node waits if there is any callbacks or events still pending. I have written a code to connect db and fetch data. The node doesn't exit even after the data is read.

var sql = require("mssql");
var config = {
    user: 'data',
    password: 'abc@123',
    server: 'localhost', 
    database: 'master' 
};
sql.connect(config, function (err) {
    var request = new sql.Request();
    var i;
    request.query('GetData').then(
        ri=>{
          console.log(ri.recordset.map(o=>o.Key));
        })

})

Can any one please help me why this is happening?

Node is not closing because sql.connext creates a active connection, so in the eyes of node a event listener is registered. Maybe try sql.close() — Dan Starns
– Dan Starns, Commented Sep 23, 2019 at 10:02

Terry Lennox · Accepted Answer · 2019-09-23 10:17:45Z

1

You can close the connection after your query is complete, this will allow the process to exit:

var sql = require("mssql");
var config = {
    user: 'data',
    password: 'abc@123',
    server: 'localhost', 
    database: 'master' 
};

sql.connect(config).then(pool => {
    var request = new sql.Request();
    request.query('GetData;').then(ri => {
        console.log(ri.recordset.map(o => o.Key));
        // Close the pool now we're done with it...
        pool.close();
    });
}).catch (err => {
    console.error("An error occurred:", err);
});

answered Sep 23, 2019 at 10:17

Terry Lennox

30.9k5 gold badges36 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Node js sql - Node program doesn't exit

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related