Uploaded image for project: 'Camel'
  1. Camel
  2. CAMEL-1047

camel-jdbc: aliases for column names don't work (select field1 as f1 from..)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Problem
    • 1.5.0
    • 2.0-M1
    • camel-jdbc
    • None

    Description

      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...

      Attachments

        Activity

          People

            Unassigned Unassigned
            matteoredaelli Matteo Redaelli
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: