Questions tagged [node-oracledb]

This tag addresses the Node.js add-on [node-oracledb] for Oracle Database

The node-oracledb add-on for powers high performance Oracle Database applications.

Use node-oracledb to connect Node.js 6, 8, 10 and 11 to Database.

394 questions
15
votes
5 answers

"npm ERR! errno 3221225477" Error in Node when making a query using oracledb

This is the error itself in the command line: npm ERR! code ELIFECYCLE npm ERR! errno 3221225477 npm ERR! versioncenter@0.0.1 start: `node ./bin/www` npm ERR! Exit status 3221225477 npm ERR! npm ERR! Failed at the versioncenter@0.0.1 start…
Levi Blodgett
  • 354
  • 1
  • 3
  • 16
12
votes
2 answers

libclntsh.so.12.1 : cannot open shared object file error when running sample of node-oracledb

My goal is to connect to a oracle database on a VMWare guest machine (OpenSuse) from Ubuntu. For now I have only installed the oracledb driver, and was trying to run the example connect program given. The steps that I am following are from the…
Ishan
  • 3,303
  • 5
  • 29
  • 47
9
votes
3 answers

Connecting to a remote Oracle DB with Nodejs through Oracledb Driver

Hey I'm really trying to figure out how to connect to a remote Oracle test DB and I have no experience in Java. So if I could get your help, I would be forever grateful. I have a remote test database I'm trying to connect to and I have a jdbc…
Brooke Clonts
  • 465
  • 1
  • 10
  • 20
7
votes
2 answers

Idle Oracle connections give error 'ORA-03114: not connected to ORACLE'

We have a Node.js web application that connects to an Oracle DB instance, The problem is after some inactivity, connections of the database is turned to read-only mode. It means SELECT operations work but INSERT and UPDATE transactions encounter…
Amir
  • 341
  • 1
  • 5
  • 16
6
votes
3 answers

Hardcoded strings are cut in half with node-oracle

I use node-oracle to connect to an Oracle db. When I select values from tables with cyrillic data, everything is fine, but if I call a procudure like this: CREATE OR REPLACE PROCEDURE TEST_ENCODING (CUR OUT SYS_REFCURSOR) AS BEGIN open cur for …
F0RR
  • 1,590
  • 4
  • 16
  • 30
5
votes
1 answer

oracledb npm Package Installation Fails

I am trying to install node-oracledb package as I wanted to connect to an Oracle database in my node.js app. However, the installation fails all the time. As I learnt by going through the error messages the cause would be the unavailability of…
Aviro
  • 2,125
  • 22
  • 28
4
votes
1 answer

How to hide credentials in a NodeJS/Express app?

I am trying to create a NodeJS server that runs locally on the clients machine. I have all the credentials to access the db in a config file and have created an exe file using pkg module so that my client can run the exe file and have the server…
abhirham
  • 151
  • 2
  • 12
3
votes
1 answer

Connection pool is never closed with node-oracledb and nodejs

I'm making a little API using Node Js and Oracle, using node-oracledb for that. I have been guided by the following article: API with OracleDB and Node JS The project files contain the following: /services/web-server.js const http =…
luisepa1420
  • 63
  • 1
  • 6
3
votes
1 answer

Node.js Oracle DB date returning wrong value

I have a date column in my DB. When querying it with SQLDeveloper like so SELECT some_date as "Some date", cast(some_date as timestamp) at time zone 'UTC' as "Some date UTC" FROM mytable FETCH NEXT 1 ROWS ONLY; I get this back When running…
Jason
  • 632
  • 1
  • 5
  • 17
3
votes
7 answers

data must be a string and salt must either be a salt string or a number of rounds

This is the error I am getting: Error: data must be a string and salt must either be a salt string or a number of rounds. This is the code that i have written is for resetting the password in my db using their email id. If this is not correct can…
Anurag
  • 95
  • 4
  • 17
3
votes
0 answers

Error: DPI-1047: 64-bit Oracle Client library cannot be loaded

I am trying to run oracledb in Node.js. const oracledb = require('oracledb'); However, the oracle is failing to initialize the client libraries. The full error is: Error: DPI-1047: 64-bit Oracle Client library cannot be loaded: "The specified…
Tomáš Zato
  • 50,171
  • 52
  • 268
  • 778
3
votes
4 answers

How to release Oracle Database connection when Node.js exits

I am using oracle database for my nodejs application. When altering any table, i am getting error resource already in used. This error getting because when terminating or when exiting the nodejs application the database connection is not getting…
Ratan Uday Kumar
  • 5,738
  • 6
  • 35
  • 54
3
votes
1 answer

How to reformat oracledb json output?

Using oracledb node.js driver with outFormat:oracledb.OBJECT option returns json, but coloumn names are formated uppercase (property names follow Oracle's standard name-casing rules), like this: {"ID":"1"} Is it possible to make them in lowercase,…
Mitrich
  • 35
  • 1
  • 4
3
votes
3 answers

node-oracledb - Bulk insert using associative array

Im using node-oracledb driver in my nodeJs application. I am having to do bulk inserts (upto 6000 rows) and the batch insert feature of simple-oracledb extension did not meet my needs. It is painfully slow for 6000 records. I came across this post…
user1220169
  • 805
  • 2
  • 9
  • 14
3
votes
4 answers

MissingDriverError when type is oracle : using typeorm

I am using typeorm in JavaScript for node and express backend like here: https://typeorm.github.io/usage-with-javascript.html node version v6.11.1 Dependencies from package.json: "@types/es6-shim": "^0.31.35", "@types/node":…
Shodhan Manda
  • 191
  • 2
  • 2
  • 8
1
2 3
26 27