web stats
Transaction handling in mirth transform - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 11-01-2018, 05:04 AM
prakashjoy prakashjoy is offline
Mirth Newb
 
Join Date: Sep 2016
Posts: 18
prakashjoy is on a distinguished road
Default 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 INTO tests_conducted (,,,,) values (?,?,?,?)";

dbConn.executeUpdate(sql);


2,
sql = "INSERT 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
Reply With Quote
Reply

Tags
javascript, transaction, transformer

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 04:25 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation