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