2002 JI Open Discussion Posted August 17, 2006 Share Posted August 17, 2006 By: Muralidhar bp - pmurli CLOB support in Jasper reports 2003-01-17 03:35 Hello, I have to develop a report, in which it consists of CLOB data. Please help me how to go with it. Thanx Murli By: Teodor Danciu - teodord RE: CLOB support in Jasper reports 2003-01-17 05:57 Hi, Pure CLOB/BLOB support is not yet available in JasperReports. Not sure, but using InputStream report fields might help. Thank you, Teodor By: Muralidhar bp - pmurli RE: CLOB support in Jasper reports 2003-01-22 02:16 Hii, How about if i write a store procedure to store the data in varchar2(32000), and pass the procedure in the query string. Thanks Murli Link to comment Share on other sites More sharing options...
brazyj Posted February 15, 2007 Share Posted February 15, 2007 Hi I am using iReport 1.2.2 as part of OSRMT v1.4. This version of iReport does not appear to support CLOBs? We instantiated OSRMT v1.4 with SQL Server Express using a separate jtsds-1.2.jar for the database connection driver. Has anyone written an extension to iReport to support the conversion of CLOBs to strings? Thanks In Advancejpb Link to comment Share on other sites More sharing options...
DMA02 Posted February 15, 2007 Share Posted February 15, 2007 brazyj wrote:Hi I am using iReport 1.2.2 as part of OSRMT v1.4. This version of iReport does not appear to support CLOBs? We instantiated OSRMT v1.4 with SQL Server Express using a separate jtsds-1.2.jar for the database connection driver. Has anyone written an extension to iReport to support the conversion of CLOBs to strings?Thanks In Advancejpb In jasper reports 1.2.8 at least it returns the CLOB Columns as one long string. But, lets say you needed to process something from a CLOB anyways. You could see what java object is returned form the CLOB column and write a small class that will take in as a parameter an object of that type. Then in there you extract the string from the CLOB and return a String object. Then in iReport place that class you coded in its classpath. Then in a Field expression call your class statically using its absolute package path (ie. mypackage.name.CLOBStringConverter.convertMyObj($F{TheCLOBColumn})) K, don't know if this will work or not cos I only tried stuff like this on v1.2.8 of jasper/iReport to convert BLOBs to text (don't ask, some progs store stuff only in bytes). Hope this helps. Link to comment Share on other sites More sharing options...
sabernethy Posted March 8, 2007 Share Posted March 8, 2007 In the release notes for JasperReports version 1.3.1 I found: "support for CLOB and BLOB report fields in JRResultSetDataSource" Does this mean JasperReports now supports CLOB fields? I am in desperate need to display a CLOB field in a report. Can someone point me in the right direction on this? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now