camel-jdbc: aliases for column names don't work (select field1 as f1 from..)
-----------------------------------------------------------------------------
Key: CAMEL-1047
URL: https://issues.apache.org/activemq/browse/CAMEL-1047
Project: Apache Camel
Issue Type: Bug
Affects Versions: 1.5.0
Reporter: Matteo Redaelli
See forum entry
http://www.nabble.com/forum/ViewPost.jtp?post=20293296&framed=y&skin=22882
With (mysql db)
<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...
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
