[jira] [Commented] (CAMEL-12901) camel-sql - Issue with complex SQL causing No endpoint could be found for:

["Dmitry Volodin (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAMEL-12901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16666950#comment-16666950 ] 

Dmitry Volodin commented on CAMEL-12901:
----------------------------------------

[~michael992], looks like you are fails with SQL statement

see JUnit for your issue and it not fails - [https://github.com/dmvolod/camel/tree/CAMEL-12901]

please also do it before submitting issues in the future.

> camel-sql - Issue with complex SQL causing 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
>            Assignee: Dmitry Volodin
>            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 table (`content`, `source`) VALUES (#, #) ON DUPLICATE KEY UPDATE `content`=VALUES(`content`)?batch=true
> {code}
> // Exception example (_No endpoint could be found for: {color:#d04437}`source`=VALUES(`source`)?batch=true{color}, please check your classpath contains the needed Camel component jar)_ :
> {code:java}
> sql:INSERT INTO table (`content`, `source`) VALUES (#, #) ON DUPLICATE KEY UPDATE `content`=VALUES(`content`), `source`=VALUES(`source`)?batch=true
> {code}



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