How to use oracle transaction with node.js

[sundarsrini]

I trying to use either 'persist' or 'oracle' to perform transactions in the oracle database through node.js program, i am not sure if there is a feasibility to do that required process or its not working for me. Kindly help!

[ioneyed]

You mention that it may no be working for you but you didn't provide a code sample? The documentation currently doesn't have an oracle example but I can assure you it works just fine with oracle as I have been using it with oracle for a couple weeks now in production.

I have forked this repo and working on a few changes that I hope will be accepted into master once I finish them. In the meantime at my forked page you can view an expanded database.json file that shows how to declare oracle with and without using TNS names.(my fork: http://github.com/ioneyed/node-persist )

If that doesnt solve your problem then please provide a gist/sample of your implementation so we can resolve your issue. Stating its just not working isn't a good way to get a resolution.

[sundarsrini]

Thanks for your response. I have added my simple code below for your perusal. Program is not executing the loop tx.rollback or tx.commit. Kind help if there is asynchronous flow or syntax issues.

var persist = require('persist');

var connectData = { driver:"oracle", hostname: "localhost", port: 1521, database: "xe", // System ID (SID) user: "tsw", password: "ts" };

persist.connect(connectData, function(err, connection){ if(err) { return console.error('could not connect to oracle', err); } else { connection.tx(function(err,tx){ connection.runSql("update emp set employee_name = :1 where employee_id = :2",["RaguSachin",320923], function(err, result){ if(err) { console.log('rollback'); tx.rollback(function(err,result) { if(err) { console.log('error in rollback'); connection.close(); } else { console.log('rollback success'); } }); } else { console.log('No error'); tx.commit(function(err,result) { if(err) { console.log('error in cvommit'); connection.close(); } else { console.log('commit success');

          }
             });
      }
       });
    });
    }

});