COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: uyravikumar on 09 Aug 2007 10:10:50 AM

Title: Blob data support in cognos
Post by: uyravikumar on 09 Aug 2007 10:10:50 AM
In Frame work manager it is providing the the data type of the query item for BLOB. but i am unable to utilize it ...

My Requirement is Placing the documents into BLOB column of Oracle database. Now I want to Display the documents which are placed in BLOB column as a report with content and format.

The documents might be Word/Excel/PDF/Image.

Please suggests me is it possible through the Cognos.

Thanks in Advance
Ravi.
Title: Re: Blob data support in cognos
Post by: COGNOiSe administrator on 09 Aug 2007 09:25:49 PM
With a pinch of java code, sure. You have to extract the BLOB and provide correct MIME type. Cognos will not do that for you.
Title: Re: Blob data support in cognos
Post by: uyravikumar on 14 Aug 2007 09:41:07 AM
Hi,

i tried changing the MIME settings in web.XML of cognos install directory and build the war file and deployed into the app server.

I am not sure where i have to write the Java code,
is it in HTML object which is placed as calculated item in list object ?

I have PDF documents stored in Oracle BLOB.
I want to show a normal list coming from normal tables and then documents contents stored in BLOB.

Please provide the Java code to do this.


Its a little bit urgent... i was eagerly waiting to see the output.

Thanks in advance
Ravi.


Title: Re: Blob data support in cognos
Post by: COGNOiSe administrator on 16 Aug 2007 07:15:51 AM
Yes, you will have to use the HTMLItem element. As for the code, try to Google BLOB JAVA PDF.
Title: Re: Blob data support in cognos
Post by: pt@tbcg on 04 Mar 2008 10:49:43 AM
Quote from: uyravikumar on 14 Aug 2007 09:41:07 AM
Hi,

i tried changing the MIME settings in web.XML of cognos install directory and build the war file and deployed into the app server.

I am not sure where i have to write the Java code,
is it in HTML object which is placed as calculated item in list object ?

I have PDF documents stored in Oracle BLOB.
I want to show a normal list coming from normal tables and then documents contents stored in BLOB.

Please provide the Java code to do this.


Its a little bit urgent... i was eagerly waiting to see the output.

Thanks in advance
Ravi.




Did you get this working?  If yes, can you share the solution (ie. the Java code)?