You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by Shishir <sh...@gmail.com> on 2013/05/15 10:17:52 UTC
Passing a list of parameters in SQL endpoint
We are using IN clause and need to supply "," delimited list of values to
the query.
So we have used a single # and the expectation is that, the entire list
should be replaced.
Tried to pass # as String String list, named parameter, but it seems camel
breaks every "," in value and try to find that many number of # in the
query. Quite sure missing something basic.
--
View this message in context: http://camel.465427.n5.nabble.com/Passing-a-list-of-parameters-in-SQL-endpoint-tp5732583.html
Sent from the Camel - Users mailing list archive at Nabble.com.
Re: Passing a list of parameters in SQL endpoint
Posted by Claus Ibsen <cl...@gmail.com>.
I logged a ticket about this
https://issues.apache.org/jira/browse/CAMEL-6418
On Thu, May 16, 2013 at 9:29 AM, Claus Ibsen <cl...@gmail.com> wrote:
> Hi
>
> Ah yeah maybe something we can improve.
>
> Can you details Camel version used. And also maybe the SQL you want to
> execute. And what your body contains.
> Then we can ponder how to improve the camel component.
>
>
>
> On Wed, May 15, 2013 at 10:17 AM, Shishir <sh...@gmail.com> wrote:
>> We are using IN clause and need to supply "," delimited list of values to
>> the query.
>>
>> So we have used a single # and the expectation is that, the entire list
>> should be replaced.
>>
>> Tried to pass # as String String list, named parameter, but it seems camel
>> breaks every "," in value and try to find that many number of # in the
>> query. Quite sure missing something basic.
>>
>>
>>
>> --
>> View this message in context: http://camel.465427.n5.nabble.com/Passing-a-list-of-parameters-in-SQL-endpoint-tp5732583.html
>> Sent from the Camel - Users mailing list archive at Nabble.com.
>
>
>
> --
> Claus Ibsen
> -----------------
> www.camelone.org: The open source integration conference.
>
> Red Hat, Inc.
> FuseSource is now part of Red Hat
> Email: cibsen@redhat.com
> Web: http://fusesource.com
> Twitter: davsclaus
> Blog: http://davsclaus.com
> Author of Camel in Action: http://www.manning.com/ibsen
--
Claus Ibsen
-----------------
www.camelone.org: The open source integration conference.
Red Hat, Inc.
FuseSource is now part of Red Hat
Email: cibsen@redhat.com
Web: http://fusesource.com
Twitter: davsclaus
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen
Re: Passing a list of parameters in SQL endpoint
Posted by Claus Ibsen <cl...@gmail.com>.
Hi
Ah yeah maybe something we can improve.
Can you details Camel version used. And also maybe the SQL you want to
execute. And what your body contains.
Then we can ponder how to improve the camel component.
On Wed, May 15, 2013 at 10:17 AM, Shishir <sh...@gmail.com> wrote:
> We are using IN clause and need to supply "," delimited list of values to
> the query.
>
> So we have used a single # and the expectation is that, the entire list
> should be replaced.
>
> Tried to pass # as String String list, named parameter, but it seems camel
> breaks every "," in value and try to find that many number of # in the
> query. Quite sure missing something basic.
>
>
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/Passing-a-list-of-parameters-in-SQL-endpoint-tp5732583.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
--
Claus Ibsen
-----------------
www.camelone.org: The open source integration conference.
Red Hat, Inc.
FuseSource is now part of Red Hat
Email: cibsen@redhat.com
Web: http://fusesource.com
Twitter: davsclaus
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen