Integration

Hi All,

I have a requirement where in I have to poll the DB for any new records and should pick up the new records. Here the polling frequency and the no:of records to be picked up should be configured. Like based on the load, the polling frequency will be changed say, from once every 5 minutes to once every hour, and also the no: of records should to be polled for should also be configurable say, 20 records for 5 minutes, 100 records for one hour(both the polling frequency and the no:of records to be picked up should be configurable).

We can change it by changing the DB Adapter configuration, which needs re-deployment which is not desired. So I am thinking if we could read the values for the polling frequency and no: of records from any other file or table and pass it as parameters to the process which polls the DB for newly inserted records.

Any light on this matter would be of great help...!!!

Thanks,
Vishwa