blob: ff72a9be57ea380c1722582bfbe8037c7b7d12fb [file] [log] [blame]
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 compile
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
Apache Karaf / ServiceMix
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
If you hit any problems please talk to us on the Camel Forums
Please help us make Apache Camel better - we appreciate any feedback you
may have. Enjoy!
The Camel riders!