Eclipse Community Forums: BIRT

Home » Archived » BIRT » Embedding images

Thu, 11 August 2005 13:54

Eclipse User

In postgres i'm storing images as bytea types. I'm selecting the data from
the
document table and when I go to access it and create an image in the report
from
it it won't render. I've traced the problem down to these lines in
ImageItemExecutor.java :

byte[] blob = null;
if ( value != null && value.getClass( ).isArray( ) &&
value.getClass( ).getComponentType( ) == byte.class ) {
blob = (byte[]) value;
}

These lines effectively limit the type of the column containing the image
data
to blobs. THe problem is blobs aren't that great in postgres and have tons
of
problems. So I use bytea objects that come back as strings in BIRT. I'm
trying
to embed an image in the report. via this tag:

<image source="expr">
<expression name="typeExpr">row["mimeType"]</expression>
<expression name="valueExpr">row["donorPicture"]</expression>
</image>Anyone figured this out? I'm going to try patching
ImageItemExecutor

Re: Embedding images [message #67627 is a reply to message #67395]

Thu, 11 August 2005 18:59

Eclipse User

Upon further investigation, the problem is actually related to how the image
is read from the db. The bytea is converted to a string without respecting
the encoding effectively destroying the image.

"Joe Rybacki" <Joe.Rybacki@dynetics.com> wrote in message
news:ddg3dl$370$1@news.eclipse.org...
>
> In postgres i'm storing images as bytea types. I'm selecting the data
> from the
> document table and when I go to access it and create an image in the
> report from
> it it won't render. I've traced the problem down to these lines in
> ImageItemExecutor.java :
>
> byte[] blob = null;
> if ( value != null && value.getClass( ).isArray( ) &&
> value.getClass( ).getComponentType( ) == byte.class ) {
> blob = (byte[]) value;
> }
>
> These lines effectively limit the type of the column containing the image
> data
> to blobs. THe problem is blobs aren't that great in postgres and have
> tons of
> problems. So I use bytea objects that come back as strings in BIRT. I'm
> trying
> to embed an image in the report. via this tag:
>
> <image source="expr">
> <expression name="typeExpr">row["mimeType"]</expression>
> <expression name="valueExpr">row["donorPicture"]</expression>
> </image>Anyone figured this out? I'm going to try patching
> ImageItemExecutor
>

Re: Embedding images [message #67742 is a reply to message #67627]

Fri, 12 August 2005 10:49

Eclipse User

Well, I finally figured it out, I had to change 3 birt jars. data,
data.oda, and report.data.oda.jdbc, the plugin.xml and manually edit my
report. I"ve attached the source changes in 3 zip files. Basically the
problem was that the binary column was converted to a string effectively
destroying the image coming out of the database. Also had to support the
byte array as an oda type.

The plugin.xml change for report.oda.jdbc:
FROM:
<dataTypeMapping
nativeDataType="BINARY"
nativeDataTypeCode="-2"
odaScalarDataType="String"/>
To:

<dataTypeMapping
nativeDataType="BINARY"
nativeDataTypeCode="-2"
odaScalarDataType="byte"/>

To embed the image element as an expression in the report file:

<image source="expr">

<expression name="typeExpr">row["mimeType"]</expression>

<expression name="valueExpr">row["picture"]</expression>

</image>

Hope this helps, Maybe this could be incorporated into the birt source code.

Thanks,
Joe

"Joe Rybacki" <Joe.Rybacki@dynetics.com> wrote in message
news:ddgl8o$mef$1@news.eclipse.org...
> Upon further investigation, the problem is actually related to how the
> image
> is read from the db. The bytea is converted to a string without
> respecting
> the encoding effectively destroying the image.
>
> "Joe Rybacki" <Joe.Rybacki@dynetics.com> wrote in message
> news:ddg3dl$370$1@news.eclipse.org...
>>
>> In postgres i'm storing images as bytea types. I'm selecting the data
>> from the
>> document table and when I go to access it and create an image in the
>> report from
>> it it won't render. I've traced the problem down to these lines in
>> ImageItemExecutor.java :
>>
>> byte[] blob = null;
>> if ( value != null && value.getClass( ).isArray( ) &&
>> value.getClass( ).getComponentType( ) == byte.class ) {
>> blob = (byte[]) value;
>> }
>>
>> These lines effectively limit the type of the column containing the image
>> data
>> to blobs. THe problem is blobs aren't that great in postgres and have
>> tons of
>> problems. So I use bytea objects that come back as strings in BIRT. I'm
>> trying
>> to embed an image in the report. via this tag:
>>
>> <image source="expr">
>> <expression name="typeExpr">row["mimeType"]</expression>
>> <expression name="valueExpr">row["donorPicture"]</expression>
>> </image>Anyone figured this out? I'm going to try patching
>> ImageItemExecutor
>>
>
>

Attachment: org.eclipse.birt.report.data.oda.jdbc-changes.zip
(Size: 1.92KB, Downloaded 220 times)
Attachment: org.eclipse.birt.data.oda-changes.zip
(Size: 4.14KB, Downloaded 199 times)
Attachment: org.eclipse.birt.data-changes.zip
(Size: 17.05KB, Downloaded 161 times)

Re: Embedding images [message #67864 is a reply to message #67742]

Fri, 12 August 2005 19:19

Eclipse User

Hi Joe,

Thanks for your contribution.
We are indeed planning to add support of the BLOB and CLOB data types in BIRT and the ODA framework in the next release.
See Bugzilla #95793: https://bugs.eclipse.org/bugs/show_bug.cgi?id=95793

Linda

Joe Rybacki wrote:

> Well, I finally figured it out, I had to change 3 birt jars. data,
> data.oda, and report.data.oda.jdbc, the plugin.xml and manually edit my
> report. I"ve attached the source changes in 3 zip files. Basically the
> problem was that the binary column was converted to a string effectively
> destroying the image coming out of the database. Also had to support the
> byte array as an oda type.
>
> The plugin.xml change for report.oda.jdbc:
> FROM:
> <dataTypeMapping
> nativeDataType="BINARY"
> nativeDataTypeCode="-2"
> odaScalarDataType="String"/>
> To:
>
> <dataTypeMapping
> nativeDataType="BINARY"
> nativeDataTypeCode="-2"
> odaScalarDataType="byte"/>
>
> To embed the image element as an expression in the report file:
>
> <image source="expr">
>
> <expression name="typeExpr">row["mimeType"]</expression>
>
> <expression name="valueExpr">row["picture"]</expression>
>
> </image>
>
> Hope this helps, Maybe this could be incorporated into the birt source code.
>
> Thanks,
> Joe
>
>
> Name: org.eclipse.birt.report.data.oda.jdbc-changes.zip
> org.eclipse.birt.report.data.oda.jdbc-changes.zip Type: WinZip File (application/x-unknown-content-type-WinZip)
> Encoding: x-uuencode
>
> Name: org.eclipse.birt.data.oda-changes.zip
> org.eclipse.birt.data.oda-changes.zip Type: WinZip File (application/x-unknown-content-type-WinZip)
> Encoding: x-uuencode
>
> Name: org.eclipse.birt.data-changes.zip
> org.eclipse.birt.data-changes.zip Type: WinZip File (application/x-unknown-content-type-WinZip)
> Encoding: x-uuencode

Previous Topic:	RHINO USAGE WARNING
Next Topic:	PDF report with bookmark ?

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Mar 11 07:22:33 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter