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 compile this example first:

mvn compile

To install Apache Camel in Karaf you type in the shell (we use version ${project.version}):

features:chooseurl camel ${project.version}
features:install camel

First you need to install the following features in Karaf/ServiceMix with:

features:install camel-blueprint
features:install camel-sql

Then you need to install JDBC connection pool and the Derby Database:

osgi:install -s mvn:commons-pool/commons-pool/1.6
osgi:install -s mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.commons-dbcp/1.4_3
osgi:install -s mvn:org.apache.derby/derby/

Then you can install the Camel example:

osgi:install -s mvn:org.apache.camel/camel-example-sql-blueprint/${project.version}

And you can see the application running by tailing the logs


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


This example is documented at

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!