Couldn't you split the resultset from the database and for each split produce a json and send that batch to your web service?
On Mon, Apr 17, 2017 at 6:45 PM, andcrow [via Camel] < [email protected]> wrote: > Still in the battle with this case ..... hehehehe > > Viewing the documentation I found the component SQL Component: > > In the options: > > maxMessagesPerPoll: Camel 2.11: SQL consumer only: An integer value to > define the maximum number of messages to gather per poll. By default, no > maximum is set. > > But also with this component he ignores this option: > > from("timer://query?fixedRate=true&delay=5s&period=10800s") > .routeId("route-product") > .setBody(constant(new ProductQuery().getProductSelect())) > to("sql:" + new ProductQuery().getProductSelect() + > "?maxMessagesPerPoll=1000&dataSource=myDataSource") > .marshal() > .json(JsonLibrary.Gson) > .setHeader(Exchange.CONTENT_TYPE, constant("application/json")) > .setHeader("CamelFileName", simple("${id}.json")) > .to("file:product"); > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > http://camel.465427.n5.nabble.com/Using-Split-with-JSON- > File-tp5797508p5797770.html > To start a new topic under Camel - Users, email > [email protected] > To unsubscribe from Camel - Users, click here > <http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=465428&code=c291Y2lhbmNlLmVxZGFtLnJhc2h0aUBnbWFpbC5jb218NDY1NDI4fDE1MzI5MTE2NTY=> > . > 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> > -- View this message in context: http://camel.465427.n5.nabble.com/Using-Split-with-JSON-File-tp5797508p5797771.html Sent from the Camel - Users mailing list archive at Nabble.com.
