Skip to main content

JBoss Fuse - File Connector with Split Pattern and JDBC connector with Error Handling - Part One

This demo is slightly longer then the ones I done before, So I will break it into 2 parts, and try to keep each section as simple as possible, and then combine 2 simple section into a bigger demo. During the process I hope you can find it's very simple to integrate, process data and information with JBoss Fuse.

Part One
=========

  • File connector
  • Split Pattern


We are going to take in XML file from different branch in a directory, each contains cash deposit, cash withdraw and transfer data, depending on the type of transaction, we spilt this XML file into different sections, then send them to different services for further process.

The format of a XML looks like this. 

 
  A02
  Gold
  
   -20
  
 
 
  A02
  Gold
  
   A01
   20
  
 




First create a route that has a file consumer endpoint that read xml files from directory, there are many different options like, readLock - locks the file when reading it , recursive -look for files in all the sub-directories as well , extra.. for more options please read the documentation. After retrieving the xml file, we are going to divide the file into different part using the Spilt pattern in Camel. The Splitter from the EIP patterns allows you split a message into a number of pieces and process them individually.


For split, we will need to specify how the message needs to be separated.  In our case, we are going to use the XPATH to indicate how the xml file is divided. (XPath is a language for addressing parts of an XML document). From our XML. file there are multiple transactions under the root element Bank, therefore the XPATH will be "//Bank/Transaction" then we send each individual xml parts to another route to process. 

    
        
        
            //Bank/Transaction
            
        
    

For each individual transaction, we get the data using XPath and set them in header, and for different types of transaction, Cash and Transfer, we send it to different route for further process.
    
        
        
            /Transaction/CustId/text()
        
        
            /Transaction/VipStatus/text()
        
        
            /Transaction/Detail/amount/text()
        
        
            ${body}
        
        
            
                /Transaction[@type='Cash']
                
            
            
                /Transaction[@type='Transfer']
                
                    /Transaction/Detail/CustId/text()
                
                
            
        
    

Lastly, for the 2 processing routes, is to export each transaction into a single xml file. So we need the file component again. This time file component is a Producer, for producer, we have fileExist- that overrides the file when exist. etc. 



    
        
        
    
    
        
        
    

If we test and place the branch-xxx.xml file into the inputdir, it will process the xml and split the file into different small pieces. 

Here is the video that shows you how to create the project. 
Demo code will be out with part 2. 



Comments

Popular posts from this blog

Fuse Integration Service - Setup JBDS and create first quickstart application

Before we go and start creating our first application, I want to show you how to setup your JBoss Developer Studio, create a small application from the quickstart example and then running it on Fuse Integration Service.

I am using JBoss Developer Studio version 9, you can find it here.
After download the

jboss-devstudio-9.0.0.GA-installer-eap.jar
double-click it, and start installing with default values.

After successful installation, we will need install the plugins for Fuse, on JBoss Central view, select software update, select enable early access.


And select JBoss Fuse Development for the plugin,


Click on install, and we are all set to go!

First thing first, we want to create a Fuse project to deploy on the base of Fuse Integration Service, which is OpenShift. If you have not installed it, please go back to my previous post for instructions. So on your JBDS, right click and start creating the project. Select new, maven project, if you have installed the plugin correctly, you should …

RHTE - Supercharge your integration services

Red Hat Tech Exchange has taken place in Vietnam, Ho Chi Minh city two weeks ago, it is a great event held by Red Hat in Asia Pacific Region. It is open to all Red Hat partners who are interested in learning what Red Hat is doing recently, see what the trend of the open source world, basically it is a great event to share your knowledge and experience, to meet other enthusiastic people.

I am very fortunate to talk in this great event, to talk about the things I have been working on and even discuss it with many. Also got lots of great ideas too. So here are the slide.

My first talk was with Thomas Qvarnström about how to handle large size data in JBoss Fuse and how JBoss Data Grid can help in the situation.

Here is the agenda of the talk, we will be talk about this in the up coming webinar on 24th Sept.

Integration often involves storing, retrieving, and transforming data. Using a traditional database in your integration is likely to becomes a bottleneck that is expensive and hard to …

Red Hat JBoss Fuse/A-MQ - Fuse and A-MQ Version 6.3 GA is released!

Fuse and A-MQ 6.3 GA has just went out. Maybe, you would think this is just only a minor version release why should I care? Hold your thoughts on that! Because they have done a lot of improvements and also added many new features into this release.

Besides various bug fixes and making sure Fuse Fabric is much more stable. There are two major change in this version update:

New Tooling in JBoss Developer Studio (JBDS) 9.1 GA. Newer Apache Camel version – Camel v2.17. I was really impressed by the work put in to make developing Camel application much simpler. First is the installation of tooling itself. Now it has a all-in-one installer so you don't need to worry about which plugins you need to check. See the videos below to see the new "Getting Started" of Fuse 6.3.



And If you notice from the above video, the presentation of camel route in JBDS has also updated. It fixed some of the miss representation of logic and making it easier to read.

Old Camel Route
New Camel Route
On …