Available as of Camel 2.11
This example is located in the
If you use maven then you can easily compile and install the example from the command line:
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.
And then in the same file we setup our Camel application. At first we have a orderBean that we use in the routes to generate new orders and process orders as well.
Notice how we have externalized the SQL queries, and use Camels property placeholder to refer to the
Using named query parameters
Notice in the SQL queries below we use named parameters which must start with prefix ':#' and then the name, eg :#amount. Then Camel will bind that parameter with the given name, from the
Running the example
This example can be run from the command line
Press ctrl + c to stop the example.