Hi Maybe you can try and let us see what it goes. I am not so sure we can make this in a way to make it not complicated. How would you specify what those IN keys are from a select statement that can return basically anything.
On Thu, Apr 6, 2017 at 6:59 PM, dvlato <[email protected]> wrote: > Hello Claus, Ibsen: > > Thank you very much for the thorough responses. We don't really need to use > the JPA component, and I think it makes more sense to use sql/jdbc for the > kind of bulk operations we want to do. > > What I think it would be really useful is to allow for the > "onConsumeBatchComplete" SQL statement to use parameters from the select > query. I mean, if the sql consumer is performing the query "select * from > mytable where status=0", I would like to be able to declare the > "onConsumeBatchComplete" query like this " update mytable set status=1 where > idfield in (:idfield)", where the idfield parameter would be populated with > the results of the select statement. > > Does my explanation make sense? I want to change the status only for the > rows returned by the select query. > > Is there another way to do that currently in Camel? I tried to connect the > output of the SQL component with another SQL component but I think I might > need a bean processor to generate the correct body. In any case, I think > that would be a useful built-in feature, so if you agree I will create a > ticket for that. > > > > > > > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Best-way-to-poll-a-database-and-process-in-chunks-tp5796094p5797098.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
