Hi 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 http://camel.apache.org/sql-component.html 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 <[email protected]> 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, > message_format_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: > http://camel.465427.n5.nabble.com/Help-with-setting-multiple-parameters-with-SQL-tp5714000.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen ----------------- FuseSource Email: [email protected] Web: http://fusesource.com Twitter: davsclaus, fusenews Blog: http://davsclaus.com Author of Camel in Action: http://www.manning.com/ibsen
