CLOB support in Jasper reports

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 Advance jpb

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.