examples/camel-example-sql-blueprint/README.adoc

== Camel SQL Blueprint Example

=== Introduction

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.

=== Build

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:

....
log:tail
....

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

=== Help and contributions

If you hit any problem using Camel or have some feedback, then please
https://camel.apache.org/support.html[let us know].

We also love contributors, so
https://camel.apache.org/contributing.html[get involved] :-)

The Camel riders!