[jira] [Resolved] (CAMEL-5977) camel-sql - Add support for map based parameters

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

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

Claus Ibsen resolved CAMEL-5977.
--------------------------------

    Resolution: Fixed

The style for named parameters is
{code}
  .to("sql:select * from projects where license = :#lic and id > :#min order by id")
{code}

The doc page for SQL component has been updated with examples.
                
> camel-sql - Add support for map based parameters
> ------------------------------------------------
>
>                 Key: CAMEL-5977
>                 URL: https://issues.apache.org/jira/browse/CAMEL-5977
>             Project: Camel
>          Issue Type: New Feature
>          Components: camel-sql
>            Reporter: Claus Ibsen
>            Assignee: Claus Ibsen
>             Fix For: 2.11.0
>
>
> Currently when using sql producer it expects the parameters in a given order.
> Though if the message body is map based, we can support key'ed style instead of index based.
> This allows us to bind t
> {code}
> select * from foo where id = #id# and country = #code#
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira