[ 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)