2 Replies Latest reply on Dec 22, 2014 2:34 AM by san_ebro

SQL binding subquery

san_ebro Dec 15, 2014 3:03 AM

Hello and thanks in advance,

is there any possibility to pass a subquery as a parameter to a query defined in SQL binding?

Thanks.

1. Re: SQL binding subquery

trohovsky Dec 15, 2014 4:56 AM (in response to san_ebro)

Hi,

it depends if you want to set the query per deployment or per message. If the first then use property substitution in switchyard.xml. If the second then you can set a new query by CamelSqlQuery header. Camel 2.14, that is used in SY 2.0, provides using of Simple expressions as parameters what might fit the best for your requirement. http://camel.apache.org/sql-component.html

Tomas
Actions
2. Re: SQL binding subquery

san_ebro Dec 22, 2014 2:34 AM (in response to trohovsky)

Hi,

thanks for the response. Setting CamelSqlQuery header with '#' replaced by subquery solved mi problem. I'm using Camel 2.10, and I guess the problem I'm facing when I try to pass a subquery as a parameter is related to comma-separated Strings https://issues.apache.org/jira/browse/CAMEL-6418

Thanks!
Actions