connection.query could not be executed with Node.js connection pooling

See more:

.NET

MySQL

connection

Node.js

, +

My stored procedure cannot executed inside connection.query, even if no error displaying in the application. What is the issue? I use following code in node js.

var mysql = require('mysql');

var db_local_config = {

    host     : 'your_host_ip',
    user     : 'userName',
    password : 'password',
    database : 'database'
};

var conLocalPool = mysql.createPool(db_local_config);


str = "call my_stored_procedure(parameters)";
            conLocalPool.getConnection(function (err, con) {
                if (err)
                    console.log('Error while performing Query.' + err);
                

                con.query(str, function (err, rows, fields) {
                    if (err)
                        console.log('Error while performing Query.' + err);
                    else {
                        console.log(rows[0]);
        
                    }
                    //con.destroy();
                    //con.end();
                    //con.release();
                });
                //mysqlPool.destroy();
                //con.end();
                
                

            });