Lydie -- I have a small learning project[1] around the sql component that
uses an in memory Derby database.
I noticed[2] that I needed to split things up like this:
from("direct:processOrderRows")
.to("sql:{{sqlstmt.selectOrder}}?dataSource=#dataSource&template.maxRows=10")
.split().body().to("sql:{{sqlstmt.markOrder}}")
.process(toStringProcessor)
.to("mock:updateDone");
While I'm using maxRows and you're using consumer.delay=5000 I think it's
kinda the same thing.
Officially, you should be able to combine things URL style. e.g.
?consumer.onConsume={{sql.oracle.markPart}} &consumer.delay=5000
I think this works and I have it working somewhere in my learning
project[1].
I hope this helps --Matt Payne
[1] https://github.com/payne/CamelSqlDemo/tree/master/CamelSqlDemo1
[2]
https://github.com/payne/CamelSqlDemo/blob/master/CamelSqlDemo1/src/test/java/org/mattpayne/demo/UpdateOrdersTest.java#L72
On Thu, Mar 20, 2014 at 5:31 PM, Lydie <[email protected]>wrote:
> Hello,
>
> I am trying to pull data from a database and mark rows as processed :
>
>
> This is working
> I am trying to use a specific delay in between each poll:
>
> ?consumer.onConsume={{sql.oracle.markPart}} ?consumer.delay=5000
>
>
> How can I do both?
> I tried:
>
>
>
> It does not work.
> I also try to use direct: but then I have an empty body when for my choice.
>
>
> Any idea?
>
>
> Thank you,
>
>
> Lydie
>
> I
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/sql-component-and-delay-tp5749161.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
--
--Matt Payne
