> On Mon, Nov 9, 2009 at 10:26 AM, marcin80 <
mtroscia@...> 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 <
mtroscia@...> 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>
