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

camel-sql - Issue with complex SQL causing No endpoint could be found for:

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Invalid
    • 2.22.1
    • None
    • camel-sql
    • None
    • Unknown

    Description

      When i try to do upsert using MySQL with ON DUPLICATE KEY clause i got en exception but only when i use more than one column.

      // Working example:

      sql:INSERT INTO table (`content`, `source`) VALUES (#, #) ON DUPLICATE KEY UPDATE `content`=VALUES(`content`)?batch=true
      

      // Exception example (No endpoint could be found for: `source`=VALUES(`source`)?batch=true, please check your classpath contains the needed Camel component jar) :

      sql:INSERT INTO table (`content`, `source`) VALUES (#, #) ON DUPLICATE KEY UPDATE `content`=VALUES(`content`), `source`=VALUES(`source`)?batch=true
      

      Attachments

        Activity

          People

            dmvolod Dmitry Volodin
            michael992 michael elbaz
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: