Thanks a lot Matt! I will look at your project.
Lydie From: MattPayneOrg [via Camel] [mailto:ml-node+s465427n574916...@n5.nabble.com] Sent: Thursday, March 20, 2014 4:11 PM To: Lydie Prevost Subject: Re: sql component and delay 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 <[hidden email]</user/SendEmail.jtp?type=node&node=5749163&i=0>>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 ________________________________ If you reply to this email, your message will be added to the discussion below: http://camel.465427.n5.nabble.com/sql-component-and-delay-tp5749161p5749163.html To unsubscribe from sql component and delay, click here<http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5749161&code=bHByZXZvc3RAY29tcGxldGVnZW5vbWljcy5jb218NTc0OTE2MXwxNjI1NjE1Mjg2>. NAML<http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> ________________________________ The contents of this e-mail and any attachments are confidential and only for use by the intended recipient. Any unauthorized use, distribution or copying of this message is strictly prohibited. If you are not the intended recipient please inform the sender immediately by reply e-mail and delete this message from your system. Thank you for your co-operation. -- View this message in context: http://camel.465427.n5.nabble.com/sql-component-and-delay-tp5749161p5749164.html Sent from the Camel - Users mailing list archive at Nabble.com.
