The BLOB object is an xml type to do process as u described. BLOB may have
any type IMAGE , PDF, ZIP etc..
in my case i am storing zip file which contains list of multi format files
as a BLOB in data base.
camel sql component has outputType=SelectOne which give us stream object
using stream objec
Read the data from database using jdbc component.
It will return ArrayList of Hashmaps. Write a java processor to loop on
this Arraylist which is in the camel body, read this blob object from the
the MAP. read it as a binary file and write it to file endpoint after
setting it in camel exchange bod