[CONF] Apache Camel: Bindy (page edited)

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[CONF] Apache Camel: Bindy (page edited)

Dhiraj Bokde (Confluence)

Bindy has been edited by Charles Moulliard (Feb 13, 2009).

(View changes)



Available as of Camel 2.0

The idea that the developers have followed to design this component was to allow the binding of non structured data (or to be more precise non-XML data)
to Java Bean using annotations. Using Bindy, you can bind data like :

  • CSV record,
  • Fixedlength record,
  • or any other non-structured data

to one or many POJOS and to convert the data according to the type of the java property. POJOS can be linked together. Moreover, for data type like Date, Double, Float, Integer, Short, Long and BigDecimal, you can provide the pattern to apply during the formatting of the property.

For the BigDecimal number, you can also define the precision and the decimal or grouping separators

Type Format Type Pattern example Link
Date DateFormat "dd-MM-yyyy" http://java.sun.com/j2se/1.5.0/docs/api/java/text/SimpleDateFormat.html
Decimal* Decimalformat "##.###.###" http://java.sun.com/j2se/1.5.0/docs/api/java/text/DecimalFormat.html

Decimal* = Double, Integer, Float, Short, Long

Be careful
This first release only support CSV record.

To work with camel-bindy, you must first define your model in a package (e.g. com.acme.model) and for each model class (e.g. Order, Client, Instrument, ...) associate the required annotations (described hereafter) with Class or property name.

Annotation name Record type Level
CsvRecord csv Class
Parameter name type Info
separator string mandatory - can be ',' or ';' or 'anything'
skipFirstLine boolean optional - default value = false - allow to skip the first line of the CSV file
    This annotation is associated to the root class of the model and must be declared one time.

case 1 : separator = ','

If the record represents orders, then this annotation is added to the Order class like this :

@CsvRecord( separator = "," )
public Class Order {

case 2 : separator = ';'

@CsvRecord( separator = ";" )
public Class Order {

case 3 : separator & skipfirstline

@CsvRecord(separator = ",", skipFirstLine = true)
public Class Order {
Annotation name Record type Level
Link all Property
Parameter name type Info
linkType LinkType optional - by default the value is LinkType.oneToOne
    Only one-to-one relation is allowed.
    e.g : If the model Class Client is linked to the Order class, then use annotation Link in the Order class like this:

private Client client

Annotation name Record type Level
DataField all Property
Parameter name type Info
int pos mandatory - digit number
pattern string optional - default value = "" - will be used to format Decimal, Date, ...
length int optional - digit number - represents the length of the field for fixed length format
precision int optional - digit number - represents the precision to be used when the Decimal number will be formatted/parsed

case 1 : position

@DataField(pos = 0)
private int orderNr;

@DataField(pos = 1)
private String ref;

case 2 : pattern

@DataField(pos = 8, pattern = "dd-MM-yyyy")
private Date orderDate;

case 3 : precision

@DataField(pos = 6, precision = 2)
private BigDecimal amount;

Using the Java DSL

The next step consists in instantiaing the DataFormat bindy class associated with this record type and providing Java package name(s) as parameter.

For example the following uses the class CsvBindyFormat (who correspond to the class associated with the CSV record type) which is configured with "com.acme.model"
package name to initialize the model objects configured in this package.

DataFormat bindy = new CsvBindyDataFormat("com.acme.model");


The Camel route will pick-up files in the inbox directory, unmarshall CSV records in a collection of model objects and send the collection
to the bean referenced by 'handleOrder'.

The collection is a list of Map. Each Map of the list contains the objects of the model. Each object can be retrieve using its class name.

int count = 0;

    List<Map<String, Object>> models = new ArrayList<Map<String, Object>>();
    Map<String, Object> model = new HashMap<String, Object>();

    models = (List<Map<String, Object>>) exchange.getIn().getBody();

    Iterator<Map<String, Object>> it = models.iterator();


          model = it.next();

	  for(String key : model.keySet()) {
	     Object obj = model.get(key);
	     LOG.info("Count : " + count + ", " + obj.toString());


    LOG.info("Nber of CSV records received by the csv bean : " + count);

To generate CSV records from a collection of model objects, you create the following route :


You can if you prefer use a named reference to a data format which can then be defined in your Registry such as via your Spring XML file. e.g.


Using Spring XML



To use Bindy in your camel routes you need to add the a dependency on camel-bindy which implements this data format.

If you use maven you could just add the following to your pom.xml, substituting the version number for the latest & greatest release (see the download page for the latest versions).