camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Reda <matteo.redae...@libero.it>
Subject camel-jdbc sql statement with "select f1 as field1 .."
Date Sun, 02 Nov 2008 20:06:06 GMT

With
 <from uri="timer://pollTheDatabase?delay=10000" />
   <setBody>
     <constant>select username as userid from mdl_user
          where firstname='' or lastname = '' or email = '' or idnumber=''
     </constant>
   </setBody>
  <to uri="jdbc:moodleDB" />

I get the error
  Column 'username' not found.

If I remove "as userid" the route works. How can add aliases for the
database column names?

Thanks
Matteo


-- 
View this message in context: http://www.nabble.com/camel-jdbc-sql-statement-with-%22select-f1-as-field1-..%22-tp20293296s22882p20293296.html
Sent from the Camel - Users mailing list archive at Nabble.com.


Mime
View raw message