camel-users mailing list archives

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

 <from uri="timer://pollTheDatabase?delay=10000" />
     <constant>select username as userid from mdl_user
          where firstname='' or lastname = '' or email = '' or idnumber=''
  <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?


View this message in context:
Sent from the Camel - Users mailing list archive at

View raw message