Error Clob Field

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

emanuel.padillaf's picture
Joined: May 9 2017 - 12:50pm
Last seen: 6 years 3 hours ago

0 Answers:

No answers yet