tree: 3ba454c420a6ea7b46b9e9e4355efe2aaa73e360 [path history] [tgz]
  1. src/
  2. pom.xml

Camel SQL Blueprint Example


This example shows how to exchange data using a shared database table.

The example has two Camel routes. The first route insert new data into the table, triggered by a timer to run every 5th second.

The second route pickup the newly inserted rows from the table, process the row(s), and mark the row(s) as processed when done; to avoid picking up the same rows again.


You will need to compile this example first: mvn install

Run with maven

To run the example type

mvn camel:run

To stop the example hit ctrl+c

This example uses Blueprint to setup and configure the database, as well the CamelContext. You can see this in the following file: In the src/main/resources/OSGI-INF/blueprint/camel-context.xml

Run with Karaf

You will need to install this example first to your local maven repository with:

mvn install

Then you can install this example from the shell using this example's features.xml for easy provisioning:

feature:repo-add mvn:org.apache.camel.example/camel-example-sql-blueprint/${version}/xml/features
feature:install camel-example-sql-blueprint

And you can see the application running by tailing the logs:


And you can use ctrl+c to stop tailing the log.

Forum, Help, etc

If you hit an problems please let us know on the Camel Forums

Please help us make Apache Camel better - we appreciate any feedback you may have. Enjoy!

The Camel riders!