camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Willem jiang <willem.ji...@gmail.com>
Subject Re: Camle sql error
Date Tue, 02 Apr 2013 08:55:11 GMT
Hi

You didn't specify the right header for the <recipientList>.
It should be start with "sql:xxx" not the sql string that you want to send to.


--  
Willem Jiang

Red Hat, Inc.
FuseSource is now part of Red Hat
Web: http://www.fusesource.com | http://www.redhat.com
Blog: http://willemjiang.blogspot.com (http://willemjiang.blogspot.com/) (English)
          http://jnn.iteye.com (http://jnn.javaeye.com/) (Chinese)
Twitter: willemjiang  
Weibo: 姜宁willem





On Tuesday, April 2, 2013 at 3:20 PM, kavan desai wrote:

> Hi
>  
> I am sending following sql statement to get it executed via Camel-sql
> component, which is giving following error.
> select complianceid,orderid from WH_STG_ORDER where parentchildtype=# and
> complianceid in (#,#,#) and currency=# and tradedate =
> to_date(#,'yyyymmdd') and ordtype is null
>  
> Error -  
>  
> org.apache.camel.NoSuchEndpointException: No endpoint could be found for:
> orderid from WH_STG_ORDER where parentchildtype=# and complianceid in
> (#,#,#) and currency=# and tradedate = to_date(#,'yyyymmdd') and ordtype is
> null?dataSourceRef=dataSource, please check your classpath contains the
> needed Camel component jar.
> at
> org.apache.camel.util.CamelContextHelper.getMandatoryEndpoint(CamelContextHelper.java:52)
> at
> org.apache.camel.util.ExchangeHelper.resolveEndpoint(ExchangeHelper.java:85)
> at
> org.apache.camel.processor.RecipientListProcessor.resolveEndpoint(RecipientListProcessor.java:219)
>  
>  
> I have already added Camel-sql dependency. If I remove second select field
> after ',' it works fine.
> Following is camel configuration  
>  
> <route id="sqlRoute">
>  
> <from uri="direct://dwh/sql-query"/>
>  
> <setHeader
> headerName="RuleCondition"><simple>${in.body.args[0]}</simple></setHeader>
>  
> <setHeader
> headerName="RuleQuery"><simple>sql://${in.body.args[0]}?dataSourceRef=dataSource</simple></setHeader>
>  
> <transform><simple>in.body.args[1]</simple></transform>
>  
> <to uri="report://request"/>
> <recipientList><header>RuleQuery</header></recipientList>
> <setHeader
> headerName="RuleCondition"><constant>RuleCondition</constant></setHeader>
> <to uri="report://reply"/>
> <log message="${body}"/>
>  
> </route>
>  
> I think ',' is not getting parsed properly,isn't it ?
>  
>  
>  
> --
> View this message in context: http://camel.465427.n5.nabble.com/Camle-sql-error-tp5730191.html
> Sent from the Camel - Users mailing list archive at Nabble.com (http://Nabble.com).




Mime
View raw message