Scenario: JDBC to IDOC.
In my production database system the records are getting inserted into the table when ever employee swipes his card,
the data will come as a new entry into table which is present in Production database TABLE_ATTENDANCE.
I configured JDBC adapter at sender side with following QUERY Statement:
Query SQL Statement: SELECT TOP 2 * from TABLE_ATTENDANCE WHERE FLAG = 0
Update SQL Statement: UPDATE TOP (2) TABLE_ATTENDANCE SET FLAG = 1 WHERE FLAG = 0
I am facing issues here as below:
Intitally My jdbc adapter is polling the table in the database and picks first 2 records 1 &2 then meanwhile few records are getting inserted and while fetching for the next poll interval it fetches 6&7 records, but where as it should fetch 3 & 4.
I want to read the records as if the same sequence in my database.
Expecting your inputs on this.