[#1092] - Postgres and Images do not mix

Category:
Bug report
Priority:
Urgent
Status:
Assigned
Project: Severity:
Critical
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

Have a column in Postgres defined as:

picture_image bytea,

This stores an image that was loaded by the Java system and needs to be displayed in the report.

Create a query in the iReport (1.2.7) to retrieve it. Change its data type to InputStream and then add an image to the report with the input set to InputStream as well. When I run the report I got a message "Error displaying report page..." with an OK button.

I can push the OK button forever as the dialog keeps coming back over and over again. Attached is a screen-shot of the Jasper Report Viewer getting bent out of shape.

AttachmentSize
Microsoft Office document icon iReportError.doc70 KB
wolfmanjacko's picture
Joined: Oct 26 2006 - 1:18pm
Last seen: 16 years 11 months ago

1 Comment:

#1

I am also facing a similar problem, However i am unable to get images from my PostgreSQL DB ver 9.3 in iReport 4.6.The images are stored in DB in a column having 'bytea[]' datatype.I have also carried out conversion of fields to java.io.InputStream still same problem persist.Kindly let me know what else to do....
Thanx in advance..

Feedback
randomness