Hi. I have a scenario where I have to poll an event log table for new entries. Conceptually I do not have write access to the database as a whole thus I have no opportunity to mark messages as read or prune processed messages.
Have considered two approaches: 1) Using the idempotent consumer approach, however am afraid that the log may grow quite large and kill performance. The table is flushed manually when the owner sees fit. 2) Somehow extend the sql consumer to sort by a defined timestamp column, store it and integrate the timestamp in the next poll (Basically the approach used by the DataImportHandler of Solr) How would you go about this using camel? Wondering if anyone has dealt with a similar scenario using Camel :) Regards Dennis -- View this message in context: http://camel.465427.n5.nabble.com/Database-polling-w-o-DB-write-access-tp5750870.html Sent from the Camel - Users mailing list archive at Nabble.com.
