...
Camel supports SQL to allow an Expression or Predicate to be used in the DSL or Xml Configuration. For example you could use SQL to create an Predicate in a Message Filter or as an Expression for a Recipient List.
To add an SQL expression to your routing rules its usually easiest to import the SqlBuilder classes methods then you can use the sql() function inside your rules.
Code Block |
---|
import static org.apache.camel.builder.sql.SqlBuilder.*; ... from("queue:foo").setBody().sql("select * from MyType")).to("queue:bar") |
And the spring DSL:
Code Block | ||||
---|---|---|---|---|
| ||||
<from uri="queue:foo"/>
<setBody>
<sql>select * from MyType</sql>
</setBody>
<to uri="queue:bar"/>
|
Variables
Variable | Type | Description |
---|---|---|
exchange | Exchange | the Exchange object |
in | Message | the exchange.in message |
out | Message | the exchange.out message |
the property key | Object | the Exchange properties |
the header key | Object | the exchange.in headers |
the variable key | Object | if any additional variables is added using |
...