Creating dynamic images from BLOBs in database
Hello everyone! I'm brand new to BIRT and was hoping someone could help me with a problem I'm having.
I'm trying to display a dynamic image in my report, but I'm hitting some issues. I'm querying the image data from our database, converting the Byte array to Base 64, and writing that Base 64 into an XML file. So, our XML data source is using Base 64 as the image data. Below is an excerpt of what it looks like in the XML file.
I tell BIRT that "cImage" is the column that I want to use and that it is a BLOB. However, whenever I run my report, I get the following error:
"org.eclipse.birt.report.engine.api.EngineException: A BIRT exception occurred. See next exception for more information. Can not convert the value of /9j/4AAQSkZJRgABAAEAYABgAAD/2wCEAAMCAgIC... to Binary type."
Should I be using something other than Base 64?
I feel as if I'm missing a very simple step and could really use some guidance since I'm a newbie. Any help would be greatly appreciated. Thank you!!