I am building one application which does some processing after looking up a database (oracle). Currently, I have configured the application with Spring Integration and it polls data in a periodic fashion despite of any data updated or inserted. The problem here is, I can not add or use any column to distinguish between old and new records. Also, for no insert or update in table as well, poller polls data from database and feeds the data into message channel. For that, I want to switch to database change notification and I need to register the query something like "SELECT * FROM EMPLOYEE WHERE STATUS='ACTIVE'", now this active status is true for old and new entries and I want to eliminate the old entries from my list. So that, only after a new insert or an existing update, I want to get data which are added newly or updated recently. Please give some lights on how should I proceed with this problem. Thanks, Sandip |