camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Claus Ibsen <>
Subject Re: Help with setting multiple parameters with SQL
Date Tue, 05 Jun 2012 07:31:13 GMT

A good idea can be to check the unit tests of a component when in doubt.

And of course as well read the doc page of the sql component

You can see that it says the message body will be iterated (see the
sample code comments),
so you can for example use a List with the values.

On Tue, Jun 5, 2012 at 2:06 AM, dmhatre <> wrote:
> Hi Folks,
>   I am using SQL component and trying to insert a message in database.
> My route:
> =====================
> <route id="dtcc-routet">
>                        <from uri="dtcc-MQ:queue:LQ_TEST?transacted=true"/>
>                        <process ref="dtccProcessor"/>
>                        <to uri="sql:insert into t_message (message_id,
> status_id, direction, message, create_ts,
> mq_msg_id,mq_correlation_id,create_user_id) values
> (SEQ_MESSAGE.NEXTVAL,#,#,#,#,#,#,#,#)"/>
>                </route>
> I need help setting the parameters from dtccprocessor so that i can just set
> the body in processor and pass to sql component which will set the value for
> message_format_id, status_id and so on.
> Is it possible to populate bean and set the body in processor and pass to
> sql component?
> Or do i need to pass it as an array of objects with parameter ordered
> maintained?
> Please help, Thanks in Advance.
> --
> View this message in context:
> Sent from the Camel - Users mailing list archive at

Claus Ibsen
Twitter: davsclaus, fusenews
Author of Camel in Action:

View raw message