Camel SQL as delta consumer

[contactreji <co...@gmail.com>]

Hi gusy

I was wondering if camel consumer endpoint has capability to pull out the
delta changes which happen on the tables?

Ex - Retrieve all those rows changed since last poll without referring on
any timestamp column.

Regards
Reji



-----
Reji Mathews
Sr. Developer - Middleware Integration / SOA ( Open Source - Apache Camel & Jboss Fuse ESB | Mule ESB )
LinkedIn - http://in.linkedin.com/pub/reji-mathews/31/9a2/40a
Twitter - reji_mathews
--
View this message in context: http://camel.465427.n5.nabble.com/Camel-SQL-as-delta-consumer-tp5791166.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel SQL as delta consumer

[Claus Ibsen <cl...@gmail.com>]

Hi

No this is not supported. There is no state in the SQL component.
You can use the idempotent consumer EIP pattern for this
http://camel.apache.org/idempotent-consumer.html

Mind that this will still query and retrieve the same rows over and
over again, then the idempotent will filter out duplicates.

Hence why its often better to have a way of marking a row as processed
in the SQL table, and hence why the SQL component has that onConsume
option.


On Wed, Dec 7, 2016 at 7:03 AM, contactreji <co...@gmail.com> wrote:
> Hi gusy
>
> I was wondering if camel consumer endpoint has capability to pull out the
> delta changes which happen on the tables?
>
> Ex - Retrieve all those rows changed since last poll without referring on
> any timestamp column.
>
> Regards
> Reji
>
>
>
> -----
> Reji Mathews
> Sr. Developer - Middleware Integration / SOA ( Open Source - Apache Camel & Jboss Fuse ESB | Mule ESB )
> LinkedIn - http://in.linkedin.com/pub/reji-mathews/31/9a2/40a
> Twitter - reji_mathews
> --
> View this message in context: http://camel.465427.n5.nabble.com/Camel-SQL-as-delta-consumer-tp5791166.html
> Sent from the Camel - Users mailing list archive at Nabble.com.



-- 
Claus Ibsen
-----------------
http://davsclaus.com @davsclaus
Camel in Action 2: https://www.manning.com/ibsen2