[jira] [Resolved] (CAMEL-10499) camel-sql - error in multiple dynamic IN replacement

["Claus Ibsen (JIRA)" <ji...@apache.org>]

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

Claus Ibsen resolved CAMEL-10499.
---------------------------------
       Resolution: Fixed
    Fix Version/s:     (was: 2.18.2)
                   2.18.1

Thanks

> camel-sql - error in multiple dynamic IN replacement
> ----------------------------------------------------
>
>                 Key: CAMEL-10499
>                 URL: https://issues.apache.org/jira/browse/CAMEL-10499
>             Project: Camel
>          Issue Type: Bug
>          Components: camel-sql
>    Affects Versions: 2.18.0
>            Reporter: Tomohisa Igarashi
>            Assignee: Tomohisa Igarashi
>             Fix For: 2.18.1, 2.19.0
>
>
> Having this sql
> {code:sql}
> select *
> from projects
> where project in (:#in:names)
> and license in (:#in:licenses)
> order by id
> {code}
> and send as following
> {code:java}
> Map<String, Object> headers = new HashMap<>();
> headers.put("names", new String[]{"Camel", "AMQ"});
> headers.put("licenses", new String[]{"ASF", "XXX", "YYY"});
> template.requestBodyAndHeaders("direct:query", "Hi there!", headers);
> {code}
> causes parameter mismatch
> {code}
> Caused by: java.sql.SQLException: Number of parameters mismatch. Expected: 4, was: 5
>         at org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy.populateStatement(DefaultSqlPrepareStatementStrategy.java:152) ~[classes/:?]
>         at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:146) ~[classes/:?]
>         at org.apache.camel.component.sql.SqlProducer$2.doInPreparedStatement(SqlProducer.java:116) ~[classes/:?]
>         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633) ~[spring-jdbc-4.3.4.RELEASE.jar:4.3.4.RELEASE]
>         ... 51 more
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)