Jasper Report Plugin v3.1.0b: using foundset not working

Classic Servoy
1

Hi everybody,

I use several Jasper Reports in Servoy. Only one uses a foundset to provide data.
They are all working fine except this foundset report.
On Developer nothing happens and there is no error raised. And on the server we get this error when we try to run it:

Exception in thread “AWT-EventQueue-0” java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Unknown Source)
at java.lang.Class.getConstructor0(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at net.sf.jasperreports.engine.JasperCompileManager.getCompiler(JasperCompileManager.java:472)
at net.sf.jasperreports.engine.JasperCompileManager.loadEvaluator(JasperCompileManager.java:238)
at net.sf.jasperreports.engine.fill.JRFillDataset.createCalculator(JRFillDataset.java:416)
at net.sf.jasperreports.engine.fill.JRBaseFiller.(JRBaseFiller.java:413)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:74)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:56)
at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:143)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:79)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624)
at com.servoy.plugins.jasperreports.JasperReportRunner.getJasperPrint(JasperReportRunner.java:300)
at com.servoy.plugins.jasperreports.JasperReportRunner.getJasperPrint(JasperReportRunner.java:111)
at com.servoy.plugins.jasperreports.JasperReportsProvider.runReport(JasperReportsProvider.java:381)
at com.servoy.plugins.jasperreports.JasperReportsProvider.js_runReport(JasperReportsProvider.java:305)
at com.servoy.plugins.jasperreports.JasperReportsProvider.js_runReport(JasperReportsProvider.java:302)
at com.servoy.plugins.jasperreports.JasperReportsProvider.js_runReport(JasperReportsProvider.java:298)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:179)
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:353)
at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:81)
at org.mozilla.javascript.gen.c191._c0(GenStateReport:56)
at org.mozilla.javascript.gen.c191.call(GenStateReport)
at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:73)
at org.mozilla.javascript.gen.c190._c0(Unknown Source)
at org.mozilla.javascript.gen.c190.call(Unknown Source)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:387)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3127)
at org.mozilla.javascript.gen.c190.call(Unknown Source)
at com.servoy.j2db.scripting.Ztb.executeFunction(Ztb.java:18)
at com.servoy.j2db.plugins.ClientPluginAccessProvider$MethodExecutor.run(ClientPluginAccessProvider.java:39)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: org.codehaus.groovy.control.CompilationFailedException
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at com.sun.jnlp.JNLPClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
… 45 more

Developer settings: Servoy 5.1.1 with Latest “Basic Servoy JasperReports Plugin v.3.1.0 beta1”
Server settings: Servoy 5.1.2 with Latest “Basic Servoy JasperReports Plugin v.3.1.0 beta1”

2

Hi!

We are using Jasper Report Plugin v3.1.0b with Servoy 5.1.2 (Developer & Server) and foundset based reports are working fine…

But the error you are getting… Could you make sure you are not using Groovy (but Java) as report language?

Best regards,

Gerardo.

3

gerardo.gomez:
Could you make sure you are not using Groovy (but Java) as report language?

How do you see that? I use iReport 3.7.1 to create the reports.

EDIT: I have found the setting! It is set to “Groovy”. I’ll try Java and let you know if it is better.

4

New problem, with Java as language, it doesn’t compile anymore and I need to modify many calculation I make in the report.

Are, reports using foundsets, not working with Groovy?!

5

I have discovered that my old jasper report plugin contained more libraries than the current one (3 in total):

  • groovy-all-1.5.5.jar
  • jcommon-1.0.15.jar
  • jfreechart-1.0.12.jar

So I have copied them in the developer folder, restarted developer and now it works!!
I need to try it on the server now.

6

Good tip Foobrother!!!

But now, (I think) you must to edit your Jasper Reports .jnlp file in order to add that .jar files references to use jasperreports plugin with SmartClient against a Server

Best regards,

Gerardo.