Monthly Archives: October 2008

Using Apache Camel with Ibatis

This is a quick tutorial about the usage of the very powerful Integration tool Apache Camel with Apache Ibatis.

Many thanks to Apache Camel forums and Claus Ibsen.

REQUIREMENTS

  • I used Java version 1.5.0_16
  • Apache Maven version 2.0.9
  • A database mysql: I used a local db “moodle”, user “moodle”, password “moodle” and a table “mdl_user” [ create table mdl_user ( id int, firstname varchar(30), lastname varchar(30), email varchar(30) ); ]

DOWNLOAD

The full sample project can be download from here!

STEP BY STEP

As suggested by http://activemq.apache.org/camel/creating-a-new-spring-based-camel-route.html

matteo@nowar:~/workspace$ mvn archetype:create \
-DarchetypeGroupId=org.apache.camel \
-DarchetypeArtifactId=camel-router \
-DarchetypeVersion=1.4.0 \
-DgroupId=org.redaelli \
-DartifactId=demo-ibatis

matteo@nowar:~/workspace$ cd demo-ibatis

matteo@nowar:~/workspace$ mvn eclipse:eclipse

matteo@nowar:~/workspace$ mvn install

Create iBatis files

  • src/main/resources/SqlMapConfig.xml
  • src/main/resources/User.xml
  • src/main/java/org/redaelli/User.java

Add the routes and dependences in the files

  • src/main/java/org/redaelli/MyRouteBuilder.java
  • pom.xml (adding dependencies “camel-ibatis” e “mysql jdbc”)

And finally run the demo with

matteo@nowar:~/workspace$ mvn camel:run

New Facebook group Binario per l'Africa

Please, join the Facebook group!

Unisciti al nuovo gruppo di Facebook di Binario per l’Africa

Please, join the Facebook group!

Unisciti al nuovo gruppo di Facebook di Binario per l’Africa

Please, join the Facebook group!

Unisciti al nuovo gruppo di Facebook di Binario per l’Africa

Please, join the Facebook group!

Unisciti al nuovo gruppo di Facebook di Binario per l’Africa