How to rollback after an insert operation was made in Javascript activity? | Community
Skip to main content
M
Mary_Joy_Gonzales
Level 2
October 16, 2019
Solved

How to rollback after an insert operation was made in Javascript activity?

  • October 16, 2019
  • 3 replies
  • 3756 views

Hi all.

I would like to ask how to rollback a transaction i.e inserted recipient made if there's an error thrown inside Javascript activity?

I found rollback() function here: https://final-docs.campaign.adobe.com/doc/AC/en/jsapi/m-DBEngine-rollback.html however, I'm not sure how to use it or if I can use it.

If there'll be a sample code, it would greatly help. Thank you so much.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Milan_Vucetic

    Hi Mary,

    by my opinion xtk.session.Write() is final statement (after execution an automatically COMMIT is done).

    It is best option to open one ticket towards Adobe Support to clarify usage of rollback().

    You might try to create a procedure on DB level (basic Oracle example below) and then adapt your web service to invoke procedure and then everything will be done by your database.

    CREATE PROCEDURE foo (x NUMBER) IS
    BEGIN
      SAVEPOINT update_bar    ;

          -- Do some inserts here.
          INSERT INTO bar VALUES (x);
          -- Sometimes there might be an error.
          IF x = 3 THEN
      RAISE_APPLICATION_ERROR    (-20000, 'Wooops...');
          END IF;
    EXCEPTION
          WHEN OTHERS THEN
           -- Rollback everything which was made after `SAVEPOINT update_bar`
           ROLLBACK TO update_bar;
      RAISE    ;
    END foo;

    Regards,

    Milan

    3 replies

    Milan_Vucetic
    Milan_Vucetic
    Level 9
    October 17, 2019

    Hi Mary,

    you may use dbEngine class to work with sql queries from JS.

    var dbEngine = instance.engine

    dbEngine.exec("UPDATE your_table SET column = 1 WHERE 1=1")

    Therefore, it is possible to use something like dbEngine.rollback() but not after the code above  because commit is done automatically. You have to write procedure in order to use commit or rollback after transaction.

    Regards,

    Milan

      M
      Mary_Joy_GonzalesAuthor
      Level 2
      October 18, 2019

      Hi Milan.

      Thank you for your response.

      I'm using xtk.session.Write() to insert/update a schema in a jssp.

      (Still new in Campaign and so far I have been using this function when doing insert/update/delete.)

      A bit of background: This jssp file is being called by AEM as a webservice.

      It has a series of processes which involves search of schema and insert/update record.

      In case there's an error thrown, I would like to rollback all the insert/update made before the error is encountered.

      Is it possible to do a rollback after that?

      Milan_Vucetic
      Milan_VuceticAccepted solution
      Level 9
      October 18, 2019

      Hi Mary,

      by my opinion xtk.session.Write() is final statement (after execution an automatically COMMIT is done).

      It is best option to open one ticket towards Adobe Support to clarify usage of rollback().

      You might try to create a procedure on DB level (basic Oracle example below) and then adapt your web service to invoke procedure and then everything will be done by your database.

      CREATE PROCEDURE foo (x NUMBER) IS
      BEGIN
        SAVEPOINT update_bar      ;

              -- Do some inserts here.
              INSERT INTO bar VALUES (x);
              -- Sometimes there might be an error.
              IF x = 3 THEN
        RAISE_APPLICATION_ERROR      (-20000, 'Wooops...');
              END IF;
      EXCEPTION
              WHEN OTHERS THEN
               -- Rollback everything which was made after `SAVEPOINT update_bar`
               ROLLBACK TO update_bar;
        RAISE      ;
      END foo;

      Regards,

      Milan

        Terms & ConditionsAccessibility statement

        Loading footer...