readme.adoc

Camel Spring Boot example with Tomcat and database connection

This example shows how to work with a simple Apache Camel Spring Boot application deploying to Tomcat and using its JDBC data source.

The example generates 2 routes:

1. The first route is triggered by a timer and writes messages to the database.

2. The second route is triggered by a timer and read the COUNT of messages from the database.

Classes

• MyCamelRouter: where the camel routes are defined

• MyBean: used to generate a simple message with a counter

• MyCamelApplication: the Spring Boot servlet initializer

How to deploy

1. Run the database container

   podman run --rm --name db -e POSTGRES_PASSWORD=password -p 5432:5432 docker.io/library/postgres:latest

2. Run the tests and package the war file

   mvn clean package

3. Copy the war file to your tomcat webapps directory

   cp target/camel-example-spring-boot.war <your_tomcat_dir>/webapps/

4. Run tomcat

   sh <your_tomcat_dir>/bin/catalina.sh run

5. Look for the log messages in the console

   [- timer://hello] ... Body: insert into messages(message) values('Hello World I am invoked 1 times')]
   [- timer://query] ... Body: There are 0 messages in the database.]
   [- timer://query] ... Body: There are 1 messages in the database.]
   [- timer://hello] ... Body: insert into messages(message) values('Hello World I am invoked 2 times')]
   [- timer://query] ... Body: There are 2 messages in the database.]
   [- timer://hello] ... Body: insert into messages(message) values('Hello World I am invoked 3 times')]
   [- timer://query] ... Body: There are 3 messages in the database.]
   [- timer://hello] ... Body: insert into messages(message) values('Hello World I am invoked 4 times')]
   [- timer://hello] ... Body: insert into messages(message) values('Hello World I am invoked 5 times')]
   [- timer://query] ... Body: There are 4 messages in the database.]

Help and contributions

If you hit any problem using Camel or have some feedback, then please let us know.

We also love contributors, so get involved :-)

The Camel riders!