EJB-QL Datasources not usable with iReport 4.x.x

[t3_chris]

 Hello!

I greatly appreciate your iReport 4.x.x releases! I am using them for SQL based reports since it's initial release.

However, there is a big Problem when trying to use an EJB-QL Query as the report's data source. If only JDK-types are used as fields to be displayed in the report, everything is fine. As soon as I include a class from my businesslogic into the report design, I get strange errors.

The following error is raised, when i add a Postalcode-object to the report design:

Creating entity manager
Closing entity manager

Error filling print... Error evaluating expression :      Source text : ""+$F{postalcode} 

net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :      Source text : ""+$F{postalcode}      at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:203)      at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589)      at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:557)      at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:867)      at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:421)      at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:406)      at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:257)      at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:468)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2037)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:761)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:291)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:133)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:903)      at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:118)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:271)      at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:954)      at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)      at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)  Caused by: java.lang.ClassCastException: com.xyz.gollum.businesslogic.Postalcode cannot be cast to com.xyz.gollum.businesslogic.Postalcode      at Rp_445145145Test_1316762737833_725853.evaluate(Rp_445145145Test_1316762737833_725853:274)      at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:190)      ... 18 more 

 

 

Most strange for me is the part marked in red.
Does anybody of you have any idea, how I can enable iReport 4 to work with EJB-QL Datasources?

 

Thanks a lot in anticipation!

 

Best Regards,

Christian

Post Edited by t3_chris at 09/23/2011 07:33