emanuel.padillaf Posted June 5, 2017 Share Posted June 5, 2017 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.stringIn 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 helpThans emmnuel 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