How do I reuse oracle connection in node.js?

Question

Can anyone assist with letting me know where I need to define the connection because I keep on getting an error. This is my first stab at this and have been at it for some time now so any help would greatly be appreciated.

var Oracle = require('oracle');


var connectData = {
    hostname: "127.0.0.1",
    port: 1521,
    database: "hr", // System ID (SID)
    user: "user",
    password: "password"
}

Oracle.connect = function(callback) {
    oracle_driver.connect(connectData, function(err, connection) {
        if (err) {
            console.log(err);
        } else {
            callback(err, connection);
        }
        connection.close();
    });
}

var statement = connection.prepare("SELECT * FROM HR where rownum < :1");

function runQuery(stmt, row_num, cb) {
    stmt.execute([row_num], function(err, count) {
        if (err) return cb(err);
        if (count !== 1) return cb(new Error("bad count: " + count));
        // We are done
        return cb();
    });
}


runQuery(statement, 90, function(err) {
    if (err) {
        console.log("Error executing query:", err);
        return;
    }

    console.log(results);
    connection.close(); // call only when query is finished executing 
});

Tracker1 · Accepted Answer · 2014-03-19 23:19:54Z

1

Unless the oracle driver already supports it, you should wrap your expensive resources into a generic-pool.

See this gist for an example of how you can create your own pool for use.

edited Mar 19, 2014 at 23:19

answered Mar 19, 2014 at 23:02

Tracker1

19.4k12 gold badges85 silver badges106 bronze badges

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

3 Comments

Tracker1 Over a year ago

If it's not self explanatory enough could do a brief example.. but generally you setup your queue with setup/teardown methods... get a connection from the pool, use it, and return it to the pool.

justZito Over a year ago

Pooling looked nice but I do not think it is for Node Oracle, I do not see it listed on the dependency.

Tracker1 Over a year ago

No, you create your own module that creates a generic pool, and that pool is loaded with oracle connections...

Collectives™ on Stack Overflow

How do I reuse oracle connection in node.js?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related