[
https://issues.apache.org/jira/browse/CAMEL-12901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16668323#comment-16668323
]
Dmitry Volodin commented on CAMEL-12901:
----------------------------------------
[~michael992] this branch contains JUnit test of your issue which is passed.
Please see SqlProducerOnDuplicateKeyTest - may be I'm missing something
https://github.com/dmvolod/camel/commit/c7612dc9c3dd752b17f0dae2a21675f2ee6478d0
> 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)
