SubDataset connection problem

[chris.mccarthy]

Hi,

I have a report that runs perfectly well in iReport. But when i run the report from the web application I get a blank report. I have narrowed the problem down to a chart within the report.  I get an exception of a null parameter map for the subdataset. THe chart has a dataset run set up to use the report JDBC connection. Can anyone help with how the subdataset must configured to run correctly. I have noticed that the connection expression does not go 'green'  Attached is a screen shot of the dataset config.

Thanks

 

[lucianc]

Subdatasets automatically receive the report's REPORT_CONNECTION when no connection expression is used.  You can see a working example in the demo/samples/charts/SubDatasetChartReport.jrxml sample report shipped with JasperReports.

If it still doesn't work for you, post your JRXML and the full exception stacktrace.

HTH,

Lucian

[chris.mccarthy]

Thanks for the reply. The report works 100% when i run it in IReport the problem only comes when i run from the application

here is the stack trace

 

java.lang.NullPointerException

at net.sf.jasperreports.engine.JRPropertiesMap.getProperty(JRPropertiesMap.java:102)

at net.sf.jasperreports.engine.util.JRProperties.getProperty(JRProperties.java:511)

at net.sf.jasperreports.engine.util.JRProperties.getIntegerProperty(JRProperties.java:549)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:144)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:103)

at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:673)

at net.sf.jasperreports.engine.fill.JRFillDataset.setDatasource(JRFillDataset.java:610)

at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:599)

at net.sf.jasperreports.engine.fill.JRFillDatasetRun.evaluate(JRFillDatasetRun.java:120)

at net.sf.jasperreports.engine.fill.JRFillElementDataset.evaluateDatasetRun(JRFillElementDataset.java:201)

at net.sf.jasperreports.engine.fill.JRFillChart.evaluateDatasetRun(JRFillChart.java:2761)

at net.sf.jasperreports.engine.fill.JRFillChart.evaluateImage(JRFillChart.java:716)

at net.sf.jasperreports.engine.fill.JRFillChart.evaluate(JRFillChart.java:705)

at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:274)

at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:400)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1273)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:614)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:209)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:109)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:751)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:660)

at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)

at net.sf.jasperreports.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:281)

at jsp_servlet._performancereport.__output._jspService(__output.java:189)

at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)

at weblogic.servlet.internal.ServletStubImpl.onAddToMapException(ServletStubImpl.java:394)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:309)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

[lucianc]

See here.

HTH,

Lucian

[chris.mccarthy]

Im still getting the same problem. I am using iReport 3.0.0 to develop the report which runs fine in iReport and my web application has the JasperReports-3.0.0.jar from the iReport bin folder in its build path.

Am i doing something really stupid here.

[lucianc]

First of all, make sure you don't have another JR jar on the classpath.  See here some hints on this.

Regards,

Lucian

[chris.mccarthy]

Thanks this has now worked. It was the Weblogic server caching the JAR files.