Skip to end of metadata
Go to start of metadata

The sql binding in SwitchYard provides database read/write support for references in SwitchYard.

The file binding is built on top of camel-sql.

SQL Binding options

Following options can be apiled to <binding.sql> definition:

  • query : SQL query to execute
  • dataSourceRef : data source name
  • batch : turn on JDBC batching
  • placeholder : a placeholder sign used to replace parameters in query
  • consume:  define the consumer attributes. This is optional.
    • delay: number of milliseconds between query executions.
    • initialDelay: a delay before query is run first time.

For detailed description of these parameters please visit camel-sql site.

Binding Services with database

For being compatible with previous versions (although not recommended), it is allowed to include in the camel:binding.sql tag the attributes.

  • period: number of milliseconds between query executions.
  • initialDelay: a delay before query is run first time.

Binding References with database

Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
  1. Nov 01, 2018

    Hi,

    How to use the Like operator in the query?

    I have tried [select * from customer where name like '%#%'] and it does not work

    Thanks!