On Mon, Nov 9, 2009 at 10:26 AM, marcin80 <[email protected]> wrote: > > Hi, > > Thanks for your help. I have other question. How shoud I do it in XML? My > Java DSL code looks like this: > > from("timer:foo?period=5000"). > setBody(constant("select dz.xx from table dz")). > > to("jdbc:dataSource").splitter(body()).convertBodyTo(String.class). > to("stream:out"); > > And I would like do it in XML: > > <camel:route> > <camel:from uri="timer:foo?period=5000"/> > <camel:setBody> > <camel:constant> > select dz.xx from table dz > </camel:constant> > </camel:setBody> > <camel:to uri="jdbc:dataSource"/> > <camel:splitter> > > <!-- what shoud I use in this place --> >
Hi Yeah the XML is not a programming language so something is not yet easily possible. I think we should add a option on the JDBC component so it can emit splitted rows for you. Please create a ticket in JIRA about this then we can fix it in the JDBC / SQL components. Otherwise you need to use a <method ref="bean" method="foo"/> And have some java code doing the splitting. > <camel:to uri="stream:out"/> > </camel:splitter> > </camel:route> > > Thanks, > Marcin > > > > Claus Ibsen-2 wrote: >> >> On Fri, Nov 6, 2009 at 1:58 PM, marcin80 <[email protected]> wrote: >>> >>> Hi, >>> >>> I have a problem with splitting of a message returned by jdbc component. >>> Jdbc component returns ArrayList<HashMap<String, Object>> but when I want >>> to >>> split it, splitter don't split this list and returns it without changing. >>> I >>> expected that splitter returns all list's elements seperately. >>> So, how can I split of result of jdbc component? I need run some logic >>> for >>> every row returned from database and I don't know how can I do it? >>> >> >> Can you show the route ? >> >> Usually in Java DSL you just do >> >> from("jdbc:xxx").split(body()).to("yyyy"); >> >> >> >>> Thanks, >>> Marcin >>> -- >>> View this message in context: >>> http://old.nabble.com/camel-jdbc-and-splitter-tp26230505p26230505.html >>> Sent from the Camel - Users mailing list archive at Nabble.com. >>> >>> >> >> >> >> -- >> Claus Ibsen >> Apache Camel Committer >> >> Author of Camel in Action: http://www.manning.com/ibsen/ >> Open Source Integration: http://fusesource.com >> Blog: http://davsclaus.blogspot.com/ >> Twitter: http://twitter.com/davsclaus >> >> > > -- > View this message in context: > http://old.nabble.com/camel-jdbc-and-splitter-tp26230505p26263321.html > Sent from the Camel - Users mailing list archive at Nabble.com. > > -- Claus Ibsen Apache Camel Committer Author of Camel in Action: http://www.manning.com/ibsen/ Open Source Integration: http://fusesource.com Blog: http://davsclaus.blogspot.com/ Twitter: http://twitter.com/davsclaus
