Tip needed: easiest way to split

View: New views
4 Messages — Rating Filter:   Alert me  

Tip needed: easiest way to split

by Bak Attila :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I have a timer-based sql query which works ok.
from("timer://foo?period=1000").
                  to("sql:select * from error?dataSourceRef=dataSource").split(???))
the result from the sql poll is coming in a list. What would be the easiest way to split this List as would need to process the retrieved rows as separate messages.
Is there a built-in mechanism for this?

Thanks
attila

Re: Tip needed: easiest way to split

by Claus Ibsen-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Wed, Oct 28, 2009 at 3:26 PM, Bak Attila <bakattila12@...> wrote:

>
> Hi,
>
> I have a timer-based sql query which works ok.
> from("timer://foo?period=1000").
>                        to("sql:select * from error?dataSourceRef=dataSource").split(???))
> the result from the sql poll is coming in a list. What would be the easiest
> way to split this List as would need to process the retrieved rows as
> separate messages.
> Is there a built-in mechanism for this?
>

Ah we could add an option like atom/rss about splitEntries.

I assume you should be able to do that in Java DSL using the splitter just by
 from("timer://foo?period=1000").
                        to("sql:select * from
error?dataSourceRef=dataSource").split(body())

As the body itself is a List which can be splitted as an list is iterateable.

But that option would be nicer as it stands out and the Spring DSL can
easier set that option.

Feel free to create a ticket in JIRA for this.




> Thanks
> attila
> --
> View this message in context: http://www.nabble.com/Tip-needed%3A-easiest-way-to-split-tp26095446p26095446.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

Re: Tip needed: easiest way to split

by Bak Attila :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi

Thanks. split(body()) works like a charm. Great piece of software although i would like to see these and other small tricks documented :)
The many ValueBuilders, Expressions can be misleading a bit when not explained in detail ;-)
I am pretty sure that there exists a built-in solution for everything i have created as of now :)

Currently i am working on a big integration project with Camel and i find it really great.

Regards,
attila


Claus Ibsen-2 wrote:
On Wed, Oct 28, 2009 at 3:26 PM, Bak Attila <bakattila12@gmail.com> wrote:
>
> Hi,
>
> I have a timer-based sql query which works ok.
> from("timer://foo?period=1000").
>                        to("sql:select * from error?dataSourceRef=dataSource").split(???))
> the result from the sql poll is coming in a list. What would be the easiest
> way to split this List as would need to process the retrieved rows as
> separate messages.
> Is there a built-in mechanism for this?
>

Ah we could add an option like atom/rss about splitEntries.

I assume you should be able to do that in Java DSL using the splitter just by
 from("timer://foo?period=1000").
                        to("sql:select * from
error?dataSourceRef=dataSource").split(body())

As the body itself is a List which can be splitted as an list is iterateable.

But that option would be nicer as it stands out and the Spring DSL can
easier set that option.

Feel free to create a ticket in JIRA for this.




> Thanks
> attila
> --
> View this message in context: http://www.nabble.com/Tip-needed%3A-easiest-way-to-split-tp26095446p26095446.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

Re: Tip needed: easiest way to split

by Claus Ibsen-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Wed, Oct 28, 2009 at 3:41 PM, Bak Attila <bakattila12@...> wrote:
>
> Hi
>
> Thanks. split(body()) works like a charm. Great piece of software although i
> would like to see these and other small tricks documented :)
> The many ValueBuilders, Expressions can be misleading a bit when not
> explained in detail ;-)

Will be documented here
Author of Camel in Action: http://www.manning.com/ibsen/



> I am pretty sure that there exists a built-in solution for everything i have
> created as of now :)
>
> Currently i am working on a big integration project with Camel and i find it
> really great.
>

Cool. I hope that Camel grow on you and you find it useable in your project.



> Regards,
> attila
>
>
>
> Claus Ibsen-2 wrote:
>>
>> On Wed, Oct 28, 2009 at 3:26 PM, Bak Attila <bakattila12@...> wrote:
>>>
>>> Hi,
>>>
>>> I have a timer-based sql query which works ok.
>>> from("timer://foo?period=1000").
>>>                        to("sql:select * from
>>> error?dataSourceRef=dataSource").split(???))
>>> the result from the sql poll is coming in a list. What would be the
>>> easiest
>>> way to split this List as would need to process the retrieved rows as
>>> separate messages.
>>> Is there a built-in mechanism for this?
>>>
>>
>> Ah we could add an option like atom/rss about splitEntries.
>>
>> I assume you should be able to do that in Java DSL using the splitter just
>> by
>>  from("timer://foo?period=1000").
>>                         to("sql:select * from
>> error?dataSourceRef=dataSource").split(body())
>>
>> As the body itself is a List which can be splitted as an list is
>> iterateable.
>>
>> But that option would be nicer as it stands out and the Spring DSL can
>> easier set that option.
>>
>> Feel free to create a ticket in JIRA for this.
>>
>>
>>
>>
>>> Thanks
>>> attila
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Tip-needed%3A-easiest-way-to-split-tp26095446p26095446.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://www.nabble.com/Tip-needed%3A-easiest-way-to-split-tp26095446p26095889.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