component sql

The SQL component lets you query a database.

URI

query

URI Examples

for a queue named 'order' just add

select orderid,amount from order

or

insert into order(orderid,amout) values (1,1000)

Service

In order to make a connection to the database you first need to create a service of type "JDBC connection". This service is required.".

Common options

• dataSource. Here you set the id of the service (note this option will be automatically set if not configured)

For all options, see Camel documentation