This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Reading data in a CLOB from BIRT report Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Reading data in a CLOB from BIRT report" Watch "Reading data in a CLOB from BIRT report" New topic
Author

Reading data in a CLOB from BIRT report

Shane W
Ranch Hand

Joined: Aug 31, 2007
Posts: 30
Hi
We are using BIRT and I need to show data stored as a CLOB on a report.IF i just put the data fetched from the DB , it gives the CLOB object id.Need to show the actual data. How do i get the reader (or stream)to this clob in BIRT?

Shane
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Don't you just bind your clob to a text control and the ODA stuff just takes care of it?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Shane W
Ranch Hand

Joined: Aug 31, 2007
Posts: 30
Hi All
The problem is now resolved.If I striaghtaway put the data fetched by the procedure on to the report, I used to get the id of the clob.The right way is to use the substring method on the clob object.
Had done it but had given the intial position as 0 instead of 1,hence was throwing illegal argument exception.
Eagle eyes of a colleague spotted the problem
 
 
subject: Reading data in a CLOB from BIRT report
 
Similar Threads
How to Integrate BIRT with Struts
Java program to Convert java.lang.String to java.sql.CLOB Object
how to cast String to Clob ?
How to Create Reports in web application using birt
Displaying Clob Data in BIRT report