You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@camel.apache.org by "michael elbaz (JIRA)" <ji...@apache.org> on 2018/10/25 20:59:00 UTC
[jira] [Updated] (CAMEL-12901) No endpoint could be found for:

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

michael elbaz updated CAMEL-12901:
----------------------------------
    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:
{code:java}
sql:INSERT INTO ${header.documentType.toString().toLowerCase()} (`content`, `source`) VALUES (#, '${header.CamelFileName}') ON DUPLICATE KEY UPDATE `content`=VALUES(`content`)?batch=true
{code}

// Exception example No endpoint could be found for: `source`=VALUES(`source`)?batch=true, please check your classpath contains the needed Camel component jar.:
{code:java}
sql:INSERT INTO ${header.documentType.toString().toLowerCase()} (`content`, `source`) VALUES (#, '${header.CamelFileName}') ON DUPLICATE KEY UPDATE `content`=VALUES(`content`), `source`=VALUES(`source`)?batch=true
{code}


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

// Working example:
{code:java}
sql:INSERT INTO ${header.documentType.toString().toLowerCase()} (`content`, `source`) VALUES (#, '${header.CamelFileName}') ON DUPLICATE KEY UPDATE `content`=VALUES(`content`)?batch=true
{code}

// Exception example No endpoint could be found for: `source`=VALUES(`source`)?batch=true, please check your classpath contains the needed Camel component jar.:
{code:java}
sql:INSERT INTO ${header.documentType.toString().toLowerCase()} (`content`, `source`) VALUES (#, '${header.CamelFileName}') ON DUPLICATE KEY UPDATE `content`=VALUES(`content`), `source`=VALUES(`source`)?batch=true
{code}



> No endpoint could be found for: 
> --------------------------------
>
>                 Key: CAMEL-12901
>                 URL: https://issues.apache.org/jira/browse/CAMEL-12901
>             Project: Camel
>          Issue Type: Bug
>          Components: camel-sql
>    Affects Versions: 2.22.1
>            Reporter: michael elbaz
>            Priority: Major
>
> 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:
> {code:java}
> sql:INSERT INTO ${header.documentType.toString().toLowerCase()} (`content`, `source`) VALUES (#, '${header.CamelFileName}') ON DUPLICATE KEY UPDATE `content`=VALUES(`content`)?batch=true
> {code}
> // Exception example No endpoint could be found for: `source`=VALUES(`source`)?batch=true, please check your classpath contains the needed Camel component jar.:
> {code:java}
> sql:INSERT INTO ${header.documentType.toString().toLowerCase()} (`content`, `source`) VALUES (#, '${header.CamelFileName}') ON DUPLICATE KEY UPDATE `content`=VALUES(`content`), `source`=VALUES(`source`)?batch=true
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)