Normally we use sender jdbc adapter in this way:
query statement:
SELECT * FROM table WHERE processed = 0
update statement:
UPDATE table SET processed = 1 WHERE processed = 0;
The update statement will be executed after the message has been successfully sent to XI.
My questions is that what will happen in this scenario:
A new record (processed=0) is added to the database table when a message is sent to XI with query statement but not finished?
After the message is sent to XI successfully, XI will execute the update statement. Then the new added reocrd will also be updated to 1 although it hasn't been sent to XI.
Does XI have some control or special check for this issue?
Regards
Hui