Announcement

Collapse
No announcement yet.

Transaction handling in mirth transform

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Transaction handling in mirth transform

    Hi,
    I am using Mirth Connect Server 3.4.2.8129.

    The channel is for reviving ORU .

    The received records i am inserting into two tables.

    The insertion is coded in the destination transformer


    1,
    sql = "INSERT IGNORE INTO tests_conducted (,,,,) values (?,?,?,?)";

    dbConn.executeUpdate(sql);


    2,
    sql = "INSERT IGNORE INTO tests_details (,,,,) values (?,?,?,?)";

    dbConn.executeUpdate(sql);


    In the above script if 2nd step failed in once scenario.

    But the 1st step execute and committed.

    Can any one suggest how to handle the transaction in this case
Working...
X