Skip to main content

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

This is the second part of the demo, "JDBC connector with Error Handling ", please take a look at the previous blog post. You can also find the finished code base here.

In the XML file, you'll find there is a VIP status, this indicates the process fee we need to charge per transaction, for DIAMOND class VIP, it's $1, $2 for GOLD and $3 for other accounts.

Using JDBC Connector, we first must create datasource setting, either within Camel context xml or in Fabric8. To make testing easy, we will set the setting in the datasource.

XML
 	
    	
    	
    	
  		
  	 
  
  	
		
  	
  
	
		
		
	
Here you will see I use the H2 Database in memory, I am using it because it's easier to setup, without the need of installing a database. If you want, you can always change it to your desire database, all you have to do is just replace the driverClassName and url, along with the ID and password to access the database. And then it's always a good idea to include an transaction manager so we can set the transaction policy. 

Before calling the jdbc component, jdbc:dataSourcePS, remember to set SQL to execute into the body. 

<setBody>
  <simple>SELECT balance from customerdemo where customerID = '${header.CustId}';</simple>
</setBody>
<to uri="jdbc:dataSourcePS?resetAutoCommit=true"/>

And we might want to capture and do something when there were error. Same as in Java programming we can specify exception policies to use and can then intercept and handle the exceptions. We can specify it by using the on Exception. After capturing the exception, we can either process it or redeliver the route again. Here is an example we use in the demo. 

    
        java.lang.Exception
        
        
            true
        
        
    

From last demo, we have process and split the XML from different bank branches into individual separate transaction. And they are group into 2 different groups, cash and transfer transaction.There are no fees when the transaction is in cash, but for Transfer, you'll find there are VIP status, this indicates the process fee we need to charge, for DIAMOND class VIP, it's $1, $2 for GOLD and $3 for other accounts.

To update the balance in database first we select to make sure we have enough balance to deduct or we will throw a not enough balance exception, which we will handle with a logging it.





Carry on from our last demo, we are going to extend the two camel route.
i) processCash





    
        
        
            SELECT balance from customerdemo where customerID = '${header.CustId}';
        
        
        
        
            UPDATE customerdemo SET balance = ${body} where customerID = '${header.CustId}';
        
        
    

Within the route you will see a java bean, it is the actual business logic to add and deduct the money from each account.


package org.blogdemo.bankdemo;

import java.util.ArrayList;
import java.util.HashMap;

import org.apache.camel.Exchange;

public class BankBean {
	int countError=0;
	
	public static final int DIAMOND_FEE = 1;
	public static final int GOLD_FEE = 2;
	public static final int NORMAL_FEE = 3;
	
	public void transfer(Exchange oldExchange, Exchange newExchange)throws Exception{
		Integer amtDeduct = ((Integer)newExchange.getIn().getHeader("amt",Integer.class));
		newExchange.getIn().setHeader("amt", amtDeduct * -1);
	}
	
	public void doBalance(Exchange oldExchange, Exchange newExchange)throws Exception{
		
		ArrayList> balanceList =(ArrayList>) newExchange.getIn().getBody(ArrayList.class);	
		HashMap result = balanceList.get(0);
		Integer newBalance = ((Integer)result.get("BALANCE")) +((Integer)newExchange.getIn().getHeader("amt",Integer.class));
		
		if("Diamond".equalsIgnoreCase(newExchange.getIn().getHeader("amt",String.class))){
			newBalance -= DIAMOND_FEE;
		}else if("Gold".equalsIgnoreCase(newExchange.getIn().getHeader("amt",String.class))){
			newBalance -= GOLD_FEE;
		}else{
			newBalance -= NORMAL_FEE;
		}
		
		if(newBalance < 0){
			throw new Exception("NOT ENOUGH BALANCE");
		}
		
		newExchange.getIn().setBody(newBalance);
		System.out.println( "--->newBalance :["+newBalance+"]" );
	} 
	
	public void doBalanceWithoutFee(Exchange oldExchange, Exchange newExchange)throws Exception{
		
		ArrayList> balanceList =(ArrayList>) newExchange.getIn().getBody(ArrayList.class);	
		HashMap result = balanceList.get(0);
		Integer newBalance = ((Integer)result.get("BALANCE")) +((Integer)newExchange.getIn().getHeader("amt",Integer.class));
		
		
		if(newBalance < 0){
			throw new Exception("NOT ENOUGH BALANCE");
		}
		
		newExchange.getIn().setBody(newBalance);
		System.out.println( "--->newBalance :["+newBalance+"] countError:["+countError+"]" );
		
	} 	
	

}


ii) doTransfer







This route is very similar with last one, but since transfer occurs between 2 accounts, so there are more select and update works to be done. Also within the route you will see a java bean, it is the actual business logic to calculate the how much to add or deduct and determine how much rate bank should charge.


    
        
        
            SELECT balance from customerdemo where customerID = '${header.CustId}';
        
        
        
        
        
            UPDATE customerdemo SET balance = ${body} where customerID = '${header.CustId}';
        
        
            SELECT balance from customerdemo where customerID = '${header.receiverId}';
        
        
        
        
        
            ${header.transfersql}  UPDATE customerdemo SET balance = ${body} where customerID = '${header.receiverId}';
        
        
    

Lastly, because we are using tables in memory, so there are some preparation needs to be done beforehand. Here is a very simple setup of creating tables and accounts in database. Also a timer that display all the account within database in log.


    
        
        
            CREATE TABLE customerdemo (customerID character varying(10) NOT NULL,vipStatus character varying(10) NOT NULL ,  balance integer NOT NULL);
        
        
    
    
        
        
            INSERT INTO customerdemo (customerID,vipStatus,balance) VALUES ('A01','Diamond',1000);
            INSERT INTO customerdemo (customerID,vipStatus,balance) VALUES ('A02','Gold',500); 
        
        
    
    
        
        
            select * from customerdemo
        
        
        
    


Here is the follow up video, please take a look at the part 1 if you have not see before. 


We can also deploy this example onto Fuse Fabric , please go to my code repo, and find the installation script, and run init.sh. 

To run the demo, in browser enter http://localhost:8181 and login with ID/PWD of admin/adminUnder Runtime, you will see list of containers, and click on the small icon on the righthand-side of the testcon container Fabric listInside the Container, under Camel tab, you will see the list of routes we have. Container Route ListClick on Endpoint on the lefthand-side, choose the file endpoint, and send the xml. Containter Endpoint SendYou will see the transfer result in the log.Container Log

Enjoy! 


Comments

Netuh said…
Hello again Christina,

I was trying to follow your tutorial and deploy this example here in my local machine.

However I got some errors. First I got a error in deploy with fabric8. The bundle creation failed due to incompatibility error.

I could workaround with this problem by adding the following lines in my pom.xml


io.fabric8
fabric8-maven-plugin
1.0.0-SNAPSHOT

http://localhost:8181/jolokia



Then the bundle is create with success, however When I create a container with the created profile. The following error appears.

Provision Exception:
org.osgi.service.resolver.ResolutionException: Unable to resolve dummy/0.0.0: missing requirement [dummy/0.0.0] osgi.identity; osgi.identity=database; type=osgi.bundle; version="[1.0.0.SNAPSHOT,1.0.0.SNAPSHOT]" [caused by: Unable to resolve database/1.0.0.SNAPSHOT: missing requirement [database/1.0.0.SNAPSHOT] osgi.wiring.package; filter:="(&(osgi.wiring.package=org.apache.commons.dbcp)(version>=1.4.0)(!(version>=2.0.0)))" [caused by: Unable to resolve org.apache.commons.dbcp/1.4.0: missing requirement [org.apache.commons.dbcp/1.4.0] osgi.wiring.package; filter:="(osgi.wiring.package=org.apache.commons.pool)"]]

Do you have a clue of the why it is not working?

thanks for the attention.
Christina Lin said…
Add Full profile in your container should solve your problem! :)

Popular posts from this blog

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 …

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 …

Red Hat JBoss Fuse - Getting Started with Fuse Integration Service 2.0 Tech preview

I just realized that I did not do a getting started for Fuse Integration Service 2.0 Tech preview before I did the pipeline demo, thanks for those of you who reminded me! :)

To get started with FIS 2.0, for people who has just getting to know the technology, here is how I interpret it. Basically, it's divide into two aspect,

1. Integration development, FIS uses Apache Camel as the core technology that creates, orchestrate, compose microservices into a super lightweight thin integration layer, and become the API provider and service orchestrator through exposing RESTful or messaging service endpoints. And you can choose to either package and run it with Spring-Boot or Karaf.


2. Application Deployment and Management, FIS takes advantages of OpenShift platform, and allows you to separately deploy the micro-integration service among distributed environment, at the same time takes care of the failover, high availability, load balancing and service lookup problem for you.


So, now we know …