blob content display report

purushdk · 2009-11-27T01:00:28+00:00

Hi, Am using birt 2.3, I am storing file content in MySql database using java and datatype blob. i need to display the blob content in the report. i have try to display as image but information is not displaying only showing empty column. Please provide some…

purushdk

Hi,

Am using birt 2.3,

I am storing file content in MySql database using java and datatype blob.

i need to display the blob content in the report.

i have try to display as image but information is not displaying only showing empty column.

Please provide some information to rectify problem.

its very urgent .

Thanks & Regards,
k.purushothaman

Find more posts tagged with

Comments

Virgil Dodson

If you are storing image data in the database, then you should be able to add an image control into the detail row of a table, select dynamic image, and then select the database field containing the image data.

SrinivasaRao

Hi,

I have followed the same steps but it is not displaying the image.

I selected the dynamic image and content field is Blob type but nothing is displaying in the report.

Please help me to solve this problem.

Regards,
Srinivas.T

Virgil Dodson

Maybe look at this example in the DevShare at 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/529-sample-birt-report-elements-example/#description'>Sample BIRT Report Elements Example - Designs & Code - BIRT Exchange</a> 
 
It shows BLOB and CLOB from a database. 
 
What format are the images stored in your database? Is it just raw images bits from bitmap or jpeg, etc? or wrapped in XML?

johnw

Make sure you are using the correct JDBC driver as well. Not all JDBC drivers for databases support blob types correctly. Some may return them as LARGECHAR as opposed to BLOBs, and some don't support them at all.

SrinivasaRao

Hi,

Thanks for your time.

I have solved this problem(problem with database blob field content).

Chris605

Hi rishwanth,
would you please be so kind to post your way of solving the problem. I have the same problem, the image is shown in the BIRT preview but it's not shown in any browser. I'm using a MySQL-Database and a MySQL-Connector v.5.1 in BIRT as well as in the web-based application. And I can access the database field containing the image data...

I also tried to use the filestream of the image and building an image with a ByteArray.. without success.

Thanks,

Chris

SrinivasaRao

<blockquote class='ipsBlockquote' data-author="'Chris605'" data-cid="60671" data-time="1266912647" data-date="23 February 2010 - 01:10 AM">
Hi rishwanth, 
 
would you please be so kind to post your way of solving the problem. I have the same problem, the image is shown in the BIRT preview but it's not shown in any browser. I'm using a MySQL-Database and a MySQL-Connector v.5.1 in BIRT as well as in the web-based application. And I can access the database field containing the image data... 
 
 
I also tried to use the filestream of the image and building an image with a ByteArray.. without success. 
 
 
Thanks, 
 
 
Chris </blockquote>
 
Hi Chris, 
 
My Sincere apologies for delay this is due to i never seen in to after this post. That's fully my wrong. 
 
In My Case the problem is with the Field Content in DB. When i posted this issue i am trying to get one image always Which have the wrong data. Itried with anothed images(Blob Content) and its done showing images and in viewer and webbrowser as well. 
 
Please let me know if you need any example what i have done. I would be more happy to share with you. 
 
Thanks, 
Srinivas.T

sanhita_sa

hi,

i have postgresql database containing images in a column[aop12_col]. I used bytea type to store images.when i create a Dataset by default the column type is blob. I tried dynamic image insert to displaying images,stored in the column.But images are not displaying when i run the report.

plz, tell me What should i do??