Insert into not working on Node.js with oracle Database

Question

today i wanna try insert data to my oracle database but the data can't saved to database here my code

async function db () {
return new Promise( async (resolve, reject) => {
    try {
      console.log("processing")
      connection = await oracle.getConnection(konek);
      var result = await connection.execute(`INSERT INTO MS_PERANGKAT (SERIALNUMBER, SSID) VALUES (:1, :2)`, ['12333', 'Rupadana']);

      connection = connection.execute("SELECT * FROM ms_perangkat");

      resolve(connection)
    } catch (err) {
      reject(err)
    } finally {
      if (connection) {
        try {
          await connection.close();
        } catch(err) {
          reject(err)
        }
      }
    }
  })
}

db().then( async connection => {
  console.log(connection)
}).catch(err => {
  console.log('Error: ',err)
});

Here the output :

{
  metaData: [ { name: 'SERIALNUMBER' }, { name: 'SSID' } ],
  rows: [ [ '12333', 'Rupadana' ] ]
}

and here my Oracle Database

I agree with Wayan. I just want to comment that the explicit promise you're returning from db seems unnecessary. Async functions automatically return promises. If the function returns a value, then that value is used to resolve the promise. If the function throws an error, the promise is rejected with that error. See this series to learn more: jsao.io/2017/06/… — Dan McGhan
– Dan McGhan, Commented Dec 7, 2019 at 2:59

Wayan Rupadana · Accepted Answer · 2019-12-07 02:02:04Z

1

that happens because the query hasn't been committed

here the code:

var result = await connection.execute(`INSERT INTO MS_PERANGKAT (SERIALNUMBER, SSID) VALUES (:1, :2)`, ['12333', 'Rupadana'],{autoCommit: true});

answered Dec 7, 2019 at 2:02

Wayan Rupadana

567 bronze badges

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

Collectives™ on Stack Overflow

Insert into not working on Node.js with oracle Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related