Is there a Node js guide on how to connect to Oracle autonomous DB ?

user10124406

Hello,

I am trying to establish a connection to an Oracle Cloud Autonomous DB connection.

Followed the instructions listed here

https://blogs.oracle.com/developers/connecting-to-autonomous-transaction-processing-database-from-a-nodejs,-python-or-ph…

But I feel some steps are missed.

Please let me know if there are detailed instructions on how to configure Node JS with oracle db .

the platform is Linux 7.

Currently I am running into

```

[[email protected] temp]# node testNode1.js

internal/modules/cjs/loader.js:638

    throw err;

    ^

Error: Cannot find module 'oracledb'

    at Function.Module._resolveFilename (internal/modules/cjs/loader.js:636:15)

    at Function.Module._load (internal/modules/cjs/loader.js:562:25)

    at Module.require (internal/modules/cjs/loader.js:692:17)

    at require (internal/modules/cjs/helpers.js:25:18)

    at Object.<anonymous> (/root/temp/testNode1.js:3:18)

    at Module._compile (internal/modules/cjs/loader.js:778:30)

    at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)

    at Module.load (internal/modules/cjs/loader.js:653:32)

    at tryModuleLoad (internal/modules/cjs/loader.js:593:12)

    at Function.Module._load (internal/modules/cjs/loader.js:585:3)

```

Note post install I dont find oracledb.js present in the $NODE_PATH

Thank you

Chs

Christopher Jones-Oracle

The Autonomous DB doc has a chapter for this:  Connect with Python, Node.js, and other Scripting Languages

Really the only extra step needed is putting the wallet files in the correct location, and perhaps (depending where you install it) editing one path in sqlnet.ora.

There may be some tips in https://static.rainfocus.com/oracle/oow19/sess/1553560683840001mfXq/PF/DEV4626-Developing-and-Deploying-Python-and-Node.js-Applications-in-Docker_1568845042122001Vsfl.pdf that could be useful.

The next (4.1) release of node-oracledb will also have a section on Autonomous DB in the node-oracledb documentation.

Personally I would just install node-oracledb from npm via normal package.json dependencies, and not use the node-oracledb RPM.  With the latter, you need to make sure NODE_PATH is set, and you don't get a choice of which version of Instant Client to use.

Christopher Jones-Oracle

The node-oracledb doc for this has gone live.  See Connecting to Oracle Autonomous Database.