Skip to main content

Red Hat JBoss Fuse - Integrating Database, Java Bean and Restful Services in EAP, XML route with JNDI

We have talked about how to start develop application in EAP without the need of Spring or CDI libraries. And in this post we are going to take that example a bit more further, show you how to integrate with Databases, Java beans in the application, creating a servlet and lastly setup a Restful webservice. We have a choice of using simple or JNDI registry, and I choose the JNDI, you will see why in a minute. If you would like to know how to do it in Java DSL with CDI or Spring XML, please go to this blogpost.

For this currency exchange project, I have store the exchange rate in the h2 database. What we are going to do is to display the entire exchange rate on the webpage provided by a restful web service and provide a servlet that takes in the amount of money and the currency to exchange to, send them back to server, calculated and return the result. So here are the things I am going to do
  • Database
  • Java Bean
  • Servlet
  • Restful Web Services

Of course we want to use the datasources in EAP. So first thing first, create the datasource in EAP. Make sure you started the JBoss EAP. Go to Configuration, select Connector and then to datasources.

  • Name :MyCamelDS
  • JNDI Name: java:jboss/datasources/MyCamelDS

 Select the Driver we are going to use, and it's h2 this case,

Enter the

  • Connection URL: jdbc:h2:file:~/h2/fuseoneap;AUTO_SERVER=TRUE
  • Username: sa
  • Password: 

Change the min and max pool size to 1 and 10. And then enable the MyCamelDS datasource.

Once we get the datasource ready, we can then use it by looking in our Route XML in the SQL component, the reason why we don't need any other work, is because we uses JNDI for Camel Registry, therefore it has the ability to lookup the datasource JNDI registry straight away.

  <route id="allcurrencies">
    <from uri="direct:getCurrencies"/>
    <log message="starting direct:getCurrencies"/>
    <to uri="sql:select * from currencyexchange?dataSource=java:jboss/datasources/MyCamelDS"/>
      <json library="Jackson"/>


Java Bean
For Java bean it is a bit more tricky, create a Java class that has a method takes in amount of money and currency to exchange first.

  public class CurrencyConvertor {
    public double convertUSD(double amt, ArrayList<Map<String, Object>> data){
      Double rate = (Double)data.get(0).get("rate");
      return amt*rate;

And then we need to figure out a way to register this CurrencyConvertor Bean in the JNDI Registry. Here we need a CamelContextLifecycle, it will define a lifecycle which could help to setup the registry. Create a Java Class that implements CamelContextLifecycle<JndiRegistry> and override the method needed.

You can now play do things in following event during the lifetime of the Camel context.
  • afterAddRoutes
  • afterStart
  • afterStop
  • beforeAddRoutes
  • beforeStart
  • beforeStop
We want register the bean before the Camel context starts, so int beforeStart method, bind the java bean into JNDI registry.

package com.redhat.demo02;

import org.apache.camel.component.servletlistener.CamelContextLifecycle;
import org.apache.camel.component.servletlistener.ServletCamelContext;
import org.apache.camel.impl.JndiRegistry;

public class MyCamelLifeCycle implements CamelContextLifecycle<JndiRegistry>{
  public void afterAddRoutes
  (ServletCamelContext camelContext, JndiRegistry registry) throws Exception {}
  public void afterStart
  (ServletCamelContext camelContext, JndiRegistry registry) throws Exception {}
  public void afterStop
  (ServletCamelContext camelContext, JndiRegistry registry) throws Exception {}
  public void beforeAddRoutes
  (ServletCamelContext camelContext, JndiRegistry registry) throws Exception {}
  public void beforeStop
  (ServletCamelContext camelContext, JndiRegistry registry) throws Exception {}
  public void beforeStart(ServletCamelContext camelContext, JndiRegistry registry) throws Exception {
     CurrencyConvertor currencyConvertor = new CurrencyConvertor();


In web.xml add the Lifecycle class you just created.


And then you will be able to call the bind bean using the Bean Component. 

  <route id="covertcurrency">
    <from uri="direct:getCurrency"/>
    <log message="Got currency: ${headers.amt} and amt${headers.currency}"/>
        <to uri="sql:select * from currencyexchange where currencycode= :#currency ?dataSource=MyCamelDS"/>
        <log message="exchange rate ====&gt; ${body[0][rate]}"/>
        <bean ref="currencyconvertor" method="convertUSD(${headers.amt},${body})"/>
        <log message="nothing to lookup"/>
          <constant>nothing to lookup</constant>


We need to setup the Servlet, under webapp, create the WEB-INF/web.xml file. Right click on Deployment Descriptor and choose Generate Deployment Descriptor Stub. It will create an empty web.xml file for you.

Add the servlet setting in the web.xml and publish it 



Once it's done, we can then use the Servlet component in Camel, it will publish a servlet endpoint through the Servlet we set earlier.

  <route id="servletCurrencies">
    <from uri="servlet:/currencies?servletName=camel&amp;matchOnUriPrefix=true"/>
    <to uri="direct:getCurrencies"/>

Restful Web Service
The Restful web services needs to have the CamelHttpTransportServlet setup too, since we have already done that in Servlet, all we have to do is to builds Rest endpoints as consumers in Rest DSL. And then configure it to servlet.

    <restConfiguration component="servlet" bindingMode="json" contextPath="/camel">
      <dataFormatProperty key="prettyPrint" value="true"/>
    <rest path="/currenciesrest">
      <get uri="/">
        <to uri="direct:getCurrencies"/>

That's all you have to do. You can find the entire project code here.


Rick said…
Thank you very much for this nice article, Christina!

The link leading to the source code seems to be inoperative. Could we please have that?
Unknown said…
This is great thank you. But for some reason in most of your articles where you write " can find the code here..." there's no link.
Unknown said…
Hi Christina,
Thank you for your work, it is a very clear introduction to Fuse. I was reading more about Karaf and saw that it is not a JEE container and therefore JTA is optional. To me this is a barrier because I want to be able to combine routes and handle/roll back transactions within my camel routes. Does this make sense, am I missing something?

Popular posts from this blog

JBoss EAP 6 - 效能調校 (一) DataSource 的 Connection Pool

效能沒有什麼Best Practice, 反正能調整的就那些。 通常,一個程式的效能大概有70-80% 都跟程式怎麼寫的其實比較有關係。

最近我最疼愛的小貓Puji 因為膀胱結石開刀的時候過世了,心情很差請原諒我的口氣沒有很好,也沒有心情寫部落格。

Puji R.I.P.



JBoss 的 SubsystemDatasource WebWeb Service EJB Hibernate JMSJCAJVM 調校OS (作業系統)

先來看一下 DataSource Subsystem, DataSource 的部分主要是針對Connection Pool 做調校。

通常,程式都會需要跟資料庫界接,電腦在本機,尤其是在記憶體的運算很快,但是一旦要外部的資源連接,就是會非常的耗資源。所以現在的應用程式伺服器都會有個Pool 放一些先連接好的 資料庫connection,當程式有需要的時候就可以馬上提供,而不用花那些多餘的資源去連接資料庫。

這就是為什麼要針對Connection Pool 去做調校。

以下會討論到的參數,都是跟效能比較有關係,Datasource 還有很多參數,像是檢核connection 是否正確的,我都不會提到。如果你追求的是非常快速的效能,那我建議你一個檢核都不要加。當然,這樣就會為伺服器上面執行的程式帶來風險。這就是你要在效能與正確,安全性上面的取捨了。 (套句我朋友說的話,不可能又要馬兒好,又要馬兒不吃草的..)

最重要的調校參數就是 Connection 的 Pool 數量。(也就是那個Pool 裡面要放幾條的connection.) 這個參數是每一個應用程式都不一樣的。


Connection Pool 最少會存留的connection 數量


Connection Pool 最多可以開啓的 connection 數量


事先將connection pool 裡面建立好min-pool-size 的connection.

我的建議是觀察一下平常程式要用到的量設定為 min-pool-size 。

My 2cents on the future of Integration - With Service Mesh/Istio and Serverless/KNative

It's been a year and half since I blogged about "Agile Integration architecture" (Gosh, time just flies). With the "microservices" and "cloud-native" hype, I was especially curious on how all these new concept and technology affect us on how to architect the integration systems. If you ever pay close attention to all the latest and greatest news from the Kubernetes community, I am sure you will hear a lot about the new "Service Mesh". And rumor has it that this is how integration can/should be done in cloud native world, but, is that so? Anyone who has ever worked on an integration project would tell you, it's a LOT more COMPLEX and can get worst overtime. I did a talk with Christian Posta in Red Hat Tech Exchange coming from a more comprehensive view of how different Red Hat technologies are applied under different patterns when building integration solutions. In fact he also did a great blog about it.

Since then, another topics has be…

Red Hat Fuse - Announcing Fuse 7 Tech preview 3 release.

Red Hat Fuse 7.0 technical preview three is out today! On the pathway to become one of the best cloud-native integration platform, Fuse gives developer freedom to choose how they want to develop the integration solution, where they want to deploy it and capabilities to address new integration personas that do not have development experience.
By supporting the three major runtime, developer is free to work on the runtime of their choice.By supporting standalone and cloud deployment, it simplifies the complexity to distinguish between these environments, allowing application to deploy freely among the environment of your choice. All levels of developers are welcome, you can either dive deep into creating customize complex integration logic, or using the new low code platform to quickly build a simple integration. In this Tech Preview release you get it all.
Fuse StandaloneSpring-boot for microserviceKaraf 4 for OSGi loverJBoss EAP for JavaEE developersFuse on OpenShiftPlugins for easy co…