camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sankalp <sankalptyagi...@gmail.com>
Subject Error while using parameterized query with mysql using camel
Date Tue, 06 Oct 2015 12:16:53 GMT

I am not able to use parameterized query with SQL select statement:
<camelContext xmlns="http://camel.apache.org/schema/spring">
                <route>
                        <from uri="timer://timer2?period=3s" />
                        <log message="select from articles"/>
                        <process ref="beanProcessor"></process>
                        <log message="${header.name}"/>
                        <setBody>
                                <constant>
                                        select * from ARTICLES where name=
:?name
                                </constant>
                        </setBody>
                        <to
uri="jdbc:dataSource?useHeadersAsParameters=true"/>
                        <to uri="log:selectLog?showHeaders=true" />
                        <log message="split rows"/>
                        <split>
                                <simple>${body}</simple>
                                <log message="process row ${body}"/>
                                <to uri="bean:rowProcessor" />
                                <to uri="stream:out"/>

                         </split>
                </route>
        </camelContext>

Bean Processor is setting the header as:exchange.getIn().setHeader("name",
name); but that value I am not able to use.I am using apache camel 2.15.2
and I tried with :#name also but it is not working




--
View this message in context: http://camel.465427.n5.nabble.com/Error-while-using-parameterized-query-with-mysql-using-camel-tp5772336.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Mime
View raw message