[jira] Resolved: (CAMEL-1047) camel-jdbc: aliases for column names don't work (select field1 as f1 from..)

["Claus Ibsen (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/activemq/browse/CAMEL-1047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Claus Ibsen resolved CAMEL-1047.
--------------------------------

    Fix Version/s: 2.0.0
       Resolution: Working as Designed

the problem is not camel but the java library ...

  http://bugs.mysql.com/bug.php?id=37038

> 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
>          Components: camel-jdbc
>    Affects Versions: 1.5.0
>            Reporter: Matteo Redaelli
>             Fix For: 2.0.0
>
>
> 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.