SQL Language

The SQL support is added by JoSQL and is primarily used for performing SQL queries on in-memory objects. If you prefer to perform actual database queries then check out the JPA component.

Looking for the SQL component
Camel has both a SQL language and a SQL Component. This page is about the SQL language. Click on SQL Component if you are looking for the component instead.

To use SQL in your camel routes you need to add the a dependency on camel-josql which implements the SQL language.

If you use maven you could just add the following to your pom.xml, substituting the version number for the latest & greatest release (see the download page for the latest versions).

<dependency>
  <groupId>org.apache.camel</groupId>
  <artifactId>camel-josql</artifactId>
  <version>2.5.0</version>
</dependency>


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.


from("queue:foo").setBody().sql("select * from MyType").to("queue:bar")



And the spring DSL:

   <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 setVariables method

Change Notification Preferences

View Online | View Changes | Add Comment

[CONF] Apache Camel > SQL

SQL

Page edited by Claus Ibsen

Changes (2)

Full Content

SQL Language

Variables

Reply via email to