Question Re: Database rollback functionality in node.js in xsa in Technology Q&A

Database rollback functionality in node.js in xsa

former_member427610 — Thu, 27 Jun 2019 15:07:40 GMT

Hi Experts,

I am developing an Node.js service to expose data from HANA in an MTA application in XSA. I have written Multiple inserts in an app.post to insert records in more than one table . I want the database to rollback the inserts if any of the insert fails.

Could you please suggest solutions to achieve the rollback functionality. I am using async and await in app.post() to execute the insert queries.

Below is the code snippets.

apppost.png dbpromise.png

Re: Database rollback functionality in node.js in xsa

former_member427610 — Thu, 27 Jun 2019 15:33:06 GMT

thomas.jung - Hi Thomas , I followed your videos in youtube and implemented the functionality . Could you please help with the database rollback functionality in node.js using await and async.

Re: Database rollback functionality in node.js in xsa

pfefferf — Thu, 27 Jun 2019 17:28:00 GMT

By default the autoCommit option is set, so each inserts commits if no error occurred. One option to reach what you wanna have is to disable the auto commit using function setAutoCommit(false) on the db connection. Then do your inserts. In case of an error execute function rollback() on the db connection. In case of no error function success(). Afterwards (in both bases) enable the autoCommit option again.

If wanna do in general the commit/rollback handling by yourself you can set the autoCommit option to false when the db connection is created.

Re: Database rollback functionality in node.js in xsa

former_member427610 — Wed, 03 Jul 2019 03:36:49 GMT

Thanks Florian . It worked.