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.
