I'm trying to use sql binding for a select query with a parameter needed in the where's clause (e.g. select id from table where column1=# and column2=# ). I noticed the placeholder field on the documentation site for SY sql: SQL - SwitchYard - Project Documentation Editor
Anyway I don't see this placeholder anywhere when I create a SQL binding. I'm using SY 1.1.0 final. I do see the "additional url parameters" option but don't think this applies. How do I configure the sql binding and pass in two dynamic parameters to the sql statement?
The parameter placeholders are filled with data from the message content. For SQL bindings, you use a converter to convert the message content to/from a form that's compatible with the Camel SQL component. Here's an example: