Error Clob Field

Posted on June 5, 2017 at 3:08pm

Hi all,

Some one can help me please...

can anybody help me?
I have a sql query that returns a huge clob field. In several pages I found that to display the field the following code is necessary this in text expression:

$F{CLOB}.getSubString( 1l, ( new Long( $F{CLOB}.length() ) ).intValue() )

The data type is java.lang.string

In the preview of ireports it works fine, however, when jasper reports executes the report it shows and error message like

net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : 
	Source text : $F{CLOB}.getSubString( 1l, ( new Long( $F{CLOB}.length() ) ).intValue() )

I have found that I need a java class to fix it, however I do not know where to apply the class or what class I have to use.

Please help

Thans emmnuel

iReport Designer