This example shows how to use camel-jdbc component with an embedded Apache Derby database.
First compile this example:
mvn compile
Now to run the example type
mvn camel:run
To stop the example hit ctrl+c
This example uses Spring to setup and configure the database, as well the CamelContext.
You can see this in the following file:
src/main/resources/META-INF/spring/camel-context.xml
The spring config setups three routes as follow:
sample-generator-route
- This route will generate sample data into database upon Camel starts.
query-update-route-part1/query-update-route-part2
- These two are connected together. It first query the database for NEW record to be process, invoke RecordProcess bean to do the work, then update the record as DONE so not to re-process on next polled.
If you hit an problems please let us know on the Camel Forums http://camel.apache.org/discussion-forums.html
Please help us make Apache Camel better - we appreciate any feedback you may have. Enjoy!
The Camel riders!