Which Camel component? Which version? Can you share your route? Best, Christian Am 19.08.2014 14:13 schrieb "[email protected]" <[email protected]>:
> HI, > > I have written this query. it is working in query builder but when try to > run through camel it shows the following error > > "com.microsoft.sqlserver.jdbc.SQLServerException: > com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name > 'ADDRESS_EMAIL'." > > > 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 > > Note : I have used the following driver > sqljdbc4 > > Let me know what went wrong. > > Thanks, > Noorul > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Sub-Query-is-not-working-with-SQL-Server-tp5755388.html > Sent from the Camel Development mailing list archive at Nabble.com. >
