| Camel SQL 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. |
| |
| Standalone |
| ---------- |
| 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 Spring to setup and configure the database, |
| as well the CamelContext. You can see this in the following file: |
| In the src/main/resources/META-INF/spring/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-spring |
| 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:commons-dbcp/commons-dbcp/1.4 |
| osgi:install -s mvn:org.apache.derby/derby/10.10.1.1 |
| |
| Then you can install the Camel example: |
| |
| osgi:install -s mvn:org.apache.camel/camel-example-sql/${project.version} |
| |
| And you can see the application running by tailing the logs |
| |
| log:tail |
| |
| And you can use ctrl + c to stop tailing the log. |
| |
| This example is documented at |
| http://camel.apache.org/sql-example.html |
| |
| If you hit any problems please talk to us 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! |