How does JDBC sender adapter reads data from DB
I have scenario where the JDBC adapter has to read the data once every month. now how would JDBC adapter know that it has to select data which has been updated after last months select only and not the old data?
in the sender JDBC adapter you give the select statement as well as update statement.
what you do is that once you select the data from data base you use an update query to set a flag to false,so that you dont select that data again next time.
have a look at this blog
in this he has used both select and update query on the sender side
Message was edited by: