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.