Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@camel.apache.org
Received-SPF: pass (athena.apache.org: domain of claus.ibsen@gmail.com
 designates 209.85.215.173 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CALvzYd-Zk4GadAzxyHZCnnu-+dK59atm2hYdfFYMS4698GX_Cg@mail.gmail.com>
References: <1322820174510-5041311.post@n5.nabble.com>
 <CALvzYd-Zk4GadAzxyHZCnnu-+dK59atm2hYdfFYMS4698GX_Cg@mail.gmail.com>
From: Claus Ibsen <claus.ibsen@gmail.com>
Date: Fri, 2 Dec 2011 11:47:07 +0100
Message-ID: 
 <CAGB5yN=9rx0acm7YjYZR_Q=B8xskTPJhgU7p2M-gPqOb==_vJA@mail.gmail.com>
Subject: Re: How can I split resultset that come from database?
To: users@camel.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Fri, Dec 2, 2011 at 11:36 AM, Christian M=FCller
<christian.mueller@gmail.com> wrote:
> Use "split(body())".
>

Yes this will work if the message body is Iterateable, such as a
Collection, Array, List etc.

However if the body is a pure javax.sql.ResultSet then that API is not
iterateable.

You could add a custom type converter from ResultSet -> Iterator
And then implement the logic there, and also implement the Closeable
interface, and close the resultset on the close() method.
The Camel splitter supports the Closeable interface.


> Best,
> Christian
>
> On Fri, Dec 2, 2011 at 11:02 AM, focaldi <ferit.ocaldi@tav.aero> wrote:
>
>> Hi, I am trying to split a resultset. My Route runs a select sql in
>> database
>> after that it will send all resultset in a message. But I need to split =
the
>> resultset and send to queue row by row. Ho can I do this? Thanks all
>>
>> --
>> View this message in context:
>> http://camel.465427.n5.nabble.com/How-can-I-split-resultset-that-come-fr=
om-database-tp5041311p5041311.html
>> Sent from the Camel - Users mailing list archive at Nabble.com.
>>


--=20
Claus Ibsen
-----------------
FuseSource
Email: cibsen@fusesource.com
Web: http://fusesource.com
Twitter: davsclaus, fusenews
Blog: http://davsclaus.blogspot.com/
Author of Camel in Action: http://www.manning.com/ibsen/