show images saved as Lage Object in Postges

using eclipse with plug-in org.eclipse.birt.resources_2.5.1.v20090821
PostgesSQL 8.4

1.create table
CREATE TABLE image
(
id bigserial NOT NULL,
bytes oid NOT NULL,
CONSTRAINT image_pkey PRIMARY KEY (id)
)

2. save object to table using
org.postgresql.largeobject.LargeObject
org.postgresql.largeobject.LargeObjectManager

3. How show this image in birt report?

Find more posts tagged with

Comments

bhanley

Make sure and include the BLOB column in your BIRT Data Set. From there, drag an image onto your report (likely in a table bound to the Data Set). For the image type, choose "Dynamic Image". This will expose a button labeled "Select Image Data". Clicking that button will allow you to choose the field in your Data Set that contains the BLOB.

Good Luck!

rehsinup

Bhanley, thanks for your reply. 
 
<blockquote class='ipsBlockquote' data-author="bhanley">Make sure and include the BLOB column in your BIRT Data Set.</blockquote>
Data Set can not contain BLOB object, database does not allow 
 
bytes oid NOT NULL, 
field "bytes" type "oid" (in terms of Birt - "Decimal" type) contains a reference to BLOB 
I know how to get the object(BLOB) from the java, c ++. but do not know how to get access from the birt report