camel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "noorul11@gmail.com" <nooru...@gmail.com>
Subject Re: Sub Query is not working with SQL Server
Date Wed, 20 Aug 2014 07:02:40 GMT
Which Camel component?
camel-jdbc

Which version?
camel version 2.13.0

Can you share your route? 

<route id="GetCustomerByEmail">  
            <from id="GetCustomerByEmail"               
uri="direct:getCustomerByEmail" />     
            <setHeader headerName="EmailId"> 
 				<simple>{{customer.emailid}}</simple> 
 			</setHeader> 
            <setBody> 
         		<constant>SELECT distinct TOP 1 MOBILE,FAX,ADDRESS_EMAIL,(case
when((select count(*) from urole where r_id = 3 and U_ID = ID)>0) then 1
else 0 end as ROLE, case when((select count(*) from urole where r_id = 4 and
u_id = ID) > 0) then 1 else 0 end as ADMIN, case when((select count(*) from
urole  where r_id = 2 and u_ID = ID)>0) then 1 else 0 end as VENDOR, case
when((select count(*) from urole  where r_id =9 and u_id = ID)>0) then 1
else 0 end as NO_SURVEY_FLAG) from myuser where ADDRESS_EMAIL = :?emailID
</constant>
      		</setBody>        
      		<to uri="jdbc:iceDataSource"/>
      		<split> 
         		<simple>${body}</simple> 
         		<log message="*** Select all : ${body}"/> 
       		</split> 
        </route> 



--
View this message in context: http://camel.465427.n5.nabble.com/Sub-Query-is-not-working-with-SQL-Server-tp5755388p5755420.html
Sent from the Camel Development mailing list archive at Nabble.com.

Mime
View raw message