Hi Have you tried to run the SQL in a SQL prompt (or editor such as DbVisualizer) to see if you get the same error there?
What database are you using? Med venlig hilsen Claus Ibsen ...................................... Silverbullet Skovsgårdsvænget 21 8362 Hørning Tlf. +45 2962 7576 Web: www.silverbullet.dk -----Original Message----- From: Reda [mailto:[EMAIL PROTECTED] Sent: 2. november 2008 21:06 To: [email protected] Subject: camel-jdbc sql statement with "select f1 as field1 .." 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.
