web stats
Mirth Community - View Single Post - Database writer keeps writing
View Single Post
  #2  
Old 08-20-2017, 08:42 PM
xiw022 xiw022 is offline
What's HL7?
 
Join Date: Aug 2017
Posts: 3
xiw022 is on a distinguished road
Default Database writer keeps writing

I'm currently developing a channel from Database reader to Database writer. Both the source and destination database are running on SQL server.

Since I set Interval in source as 5 milliseconds, the channel insert new data into the destination database every 5 milliseconds, even if the data has been polled from the source database and be inserted before. This results in infinite insertion into the destination database infinitely.

For example, if I only have one row in the source database, the channel will insert the one row infinitely times into the destination database.

Is there any way to prevent from insertion of duplicate values(insert only if source has been updated and the value has not been inserted into the destination before).
Attached Files
File Type: xml testTwoRow2.xml (23.3 KB, 10 views)
Reply With Quote