Insert data into an oracle database table in NodeJS

Question

I would like to insert data into an Oracle database table by using insertIntoTable which is referenced in the code below; The function isn't working but without it, the query works as intended.

let connection;
var oracledb = require('oracledb');

(async function() {
try{

    connection = await oracledb.getConnection({
    user : 'demo7',
    password : 'dbpass',
    connectString : 'localhost/induspdb'
    });
    console.log("Successfully connected to Oracle!");

  //function which insert result into table
    async function insertIntoTable(dateToday, fileFound, fileNotFound )
    {
    const query='insert into backupinfo (infdate,found,notfound) values (:1,:2,:3)';
    var binds=[dateToday,fileFound,fileNotFound];
    await connection.execute(query , binds, {autoCommit:true}); 
    }

  // module.exports.insertIntoTable=insertIntoTable;
  insertIntoTable('2019-09-06','rtx','agh');

} catch(err) {
    console.log("Error: ", err);
  } finally {
    if (connection) {
      try {
        await connection.close();
      } catch(err) {
        console.log("Error when closing the database connection: ", err);
      }
    }
  }

})()

Whenever I call this function and pass given arguments, this function should insert values into the table, here is the error output:

Successfully connected to Oracle!

    (node:10088) UnhandledPromiseRejectionWarning: Error: DPI-1010: not connected
    (node:10088) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an as
    ync function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
    (node:10088) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are n
    ot handled will terminate the Node.js process with a non-zero exit code.

I don't know Node at all, but your database code/logic seems OK to me, at least at a quick glance. — Tim Biegeleisen
– Tim Biegeleisen, Commented Sep 6, 2019 at 10:02
I see this has been answered, but don't forget to review the documentation such as oracle.github.io/node-oracledb/doc/api.html#inbind and oracle.github.io/node-oracledb/doc/api.html#batchexecution — Christopher Jones
– Christopher Jones, Commented Sep 7, 2019 at 2:13

idanf · Accepted Answer · 2019-09-06 11:20:46Z

1

Check that all the params of the binds are valid according the table type in the db. In addition, add before insertIntoTable "await" so the error wont be UnhandledPromiseRejection, and will be clearer.

answered Sep 6, 2019 at 11:20

idanf

849 bronze badges

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

3 Comments

JAWAD KHAN Over a year ago

but in another js file when I call this await serverConnection.insertIntoTable(todayDate, fileF, fileNF); it give same error can you please help me to fix this also.

Dan McGhan Over a year ago

@JAWADKHAN Create a new question and include the code that's not working. You might want to work through this series: jsao.io/2017/06/… See the links at the bottom which cover callbacks, the Async module, promises, and async/await.

idanf Over a year ago

JAWADKHAN, Did you figure it out? If not send the current code so i will help.

Shravan Hebbar · Accepted Answer · 2019-09-06 11:58:33Z

0

Don’t release connections until you are done with them Otherwise you will get DPI-1010 error. Check your async logic once again

edited Sep 6, 2019 at 11:58

answered Sep 6, 2019 at 11:52

Shravan Hebbar

2092 silver badges7 bronze badges

Collectives™ on Stack Overflow

Insert data into an oracle database table in NodeJS

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related