Connecting to Oracle database with Node.js Windows

Question

I am trying to connect to an Oracle database from Node.js in Windows 7. Is this possible? I have not found a plugin for Node.js which will do this for Windows. Are there any recommended work arounds for this? I am guessing there is at least one other person wanting to use Node.js on Windows and needs to connect to Oracle. I'm open to simple workarounds if that is necessary. Thanks for the help.

A simple work around is using a C++ oracle driver and exposing access to it as a c++ extension to node — Raynos
– Raynos, Commented Apr 4, 2012 at 19:19
Do you have any recommended resources for going about that? I am suspecting I'll have to do something like that but I'm looking for guidance. Thanks for the comment. — Matthew Crews
– Matthew Crews, Commented Apr 4, 2012 at 19:25
I'm sorry but I didn't. Ultimately what I had to do was have a Powershell script pull that data out of the database and dump it into a CSV. I then had NodeJS pull the data into MongoDB. I'm sorry I don't have better news for you. — Matthew Crews
– Matthew Crews, Commented Aug 5, 2012 at 15:56

Matthew Watson · Accepted Answer · 2012-04-04 22:59:38Z

2

Do you need to connect directly from Node.js to oracle? You could write your database transactions in another language and expose them to Node.js via a web service.

answered Apr 4, 2012 at 22:59

Matthew Watson

14.3k9 gold badges65 silver badges82 bronze badges

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

2 Comments

Matthew Crews Over a year ago

Ideally I would connect directly to Oracle from Node.js. If this isn't feasible I'd like to know the easiest workaround. I'm not sure how writing the transactions in another language would work. If there is an example on how to do this, I'd love to see it.

Matthew Crews Over a year ago

I've that the easiest solution would be to create a data provider using another language which has more support. I'm going to try compiling a native module and found this link to be a good starting point: github.com/saary/node.net

saille · Accepted Answer · 2015-10-08 02:09:11Z

The state of database drivers for node.js on Windows seems somewhat immature compared to the robust and highly performant database drivers we have had available in ADO.NET for years.

I would seriously consider using Edge to call C# or a CLR assembly in-process to access your database. You could write a Repository style data access layer in C# and call it from node.js.

I have proven this works in a development context with C#, PetaPoco (optional), .NET 4.5 and the Oracle ODP driver (Oracle.DataAccess.dll). This should also work with any database that you can talk to in .NET.

Node (server.js) example to call .NET CLR function:

var edge = require('edge');

// define CLR function proxy
var getData = edge.func({
    assemblyFile: '../Repositories/bin/Debug/Repositories.dll',
    typeName: 'Repositories.TestRepository',
    methodName: 'GetData' // This must be Func<object,Task<object>>
});

// call proxy function
getData({ myParam:1 }, function (error, result) {
    if (error) throw error;
    console.log(result);
});

GetData C# looks like this (note you need to put your connection string in node.exe.config in the folder that contains node.exe):

public async Task<object> GetData(object param)
{
    using (var db = new Database("NameOfConnString"))
    {
        return db.Fetch<dynamic>("SELECT * FROM sometable");
    }
}

(Note that Oracle.DataAccess.dll needs to be in the folder that contains node.exe.)

Parvez · Accepted Answer · 2015-10-29 08:12:35Z

1

There is a driver made by Oracle oracledb http://www.oracle.com/technetwork/database/database-technologies/node_js/oracle-node-js-2399407.html

UPDATE: Oracle has released a node-oracledb driver on GIT that will allow a nodejs application to connect to oracle DB on windows.

edited Oct 29, 2015 at 8:12

Parvez

6411 gold badge6 silver badges19 bronze badges

answered Jun 12, 2015 at 18:48

Roia

111 bronze badge

1 Comment

Benny Bottema Over a year ago

Hi, welcome to SO! Please provide some example code or elaborate on your answer: link-only answers tend to become stale as hyperlinks die. Anything else you can add to your answer to provide some context?

Community · Accepted Answer · 2017-05-23 12:15:40Z

0

This driver works on Window: https://npmjs.org/package/oracle

A similar question as yours here on Stack Overflow: Connect Node.js with Oracle on Windows platform

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Sep 20, 2013 at 10:23

Filip

6524 silver badges8 bronze badges

Comments

mwrf · Accepted Answer · 2015-04-15 08:50:37Z

0

http://github.com/mariano/node-db-oracle This project aims to add oracle support to nodejs

EDIT: There is now an office nodejs driver for Oracle, by Oracle called node-oracle

https://blogs.oracle.com/opal/entry/introducing_node_oracledb_a_node

edited Apr 15, 2015 at 8:50

answered Apr 12, 2012 at 21:14

mwrf

3,8561 gold badge16 silver badges10 bronze badges

Collectives™ on Stack Overflow

Connecting to Oracle database with Node.js Windows

5 Answers 5

2 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest