prkothan

Dear teodord, Please let us know when this fix will be available for GeneralUse. regards, Prasanna

Hi all, We are facing bit wierd issue with CSV reports. 1. When we hard code the query (with all where conditions) the order the data given by CSV reports matches with order of data provided by SQL Editor (Toad). 2. When we pass the where conditions as paramaters, the order the data given by CSV reports is different from order of data provided by SQL Editor (Toad). Both the queries has the same order by field. I tried to find the actual data returned by DB by using P6Spy driver (wrapper over Oracle JDBC driver) which provides the actual log of query fired and result sets obtained. The findings are, the query fired is 100% same, but the results has different ordering. My common sense its not a Jasper issue. But I don't understand DB is given different ordering for the same that too when where conditions passed as paramaters. Please help. Post Edited by prkothan at 03/09/2011 08:16

Hi, We experince with recent iReport 3.7.3 is, its much slower and unresponsive (that if we leave idle for 10-15 mins it becomes totally unresponsive). We didn't faced this issue with 3.1.0. My machine configuration is quad core (2.57 Ghz speed) and 4GB RAM. This is affecting our team's productivity. Please suggest what we should do. Regards, Prasanna Post Edited by prkothan at 12/07/2010 09:46

We too hitting the same set of problems. 1. Class loading problem. Applied the same fix. Now the same SQL related exception. Please help. Regards, Prasanna

Adding this line in compile () method of JRAntCompileTask.java class solved the issue. Thread.currentThread().setContextClassLoader(this.getClass().getClassLoader()); Regards, Prasanna

Identified the cause, but issue is not resolved. Cause is, from Jasper 3.1.1, JRXMLDesignFactory.java has enabled usage of contextClassLoader in the method configureDigester. digester.setUseContextClassLoader(true); As described in below links, Ant doesn't set the context classloader before invoking a task. http://webui.sourcelabs.com/ant/issues/36717 https://issues.apache.org/bugzilla/show_bug.cgi?id=36717 https://issues.apache.org/bugzilla/show_bug.cgi?id=15018 And this should be taken care by customTask (JRAntCompileTask). Actually execute() method set the contextClassLoader, still its not sufficient. Please reply. Regards, Prasanna

Hi, We are currently using ant task (net.sf.jasperreports.ant.JRAntCompileTask) to compile out 150 more reports. And we are migrating from 2.0.5. Ant task works properly with 2.0.5 and 3.1.0. But its doesn't works with Jasper reports 3.5.0. And it doesn't works for the version 3.1.1 or greater. But we able to compile the reports programmatically using java file or via ireports. And its run properly while generating reports. Just ant task compilation is not working. We are getting following exception. jasper-report: [jrc] 20:05:59,639 DEBUG sax:1249 - setDocumentLocator(com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser$LocatorProxy@1117a20) [jrc] 20:05:59,639 DEBUG sax:1283 - startDocument() [jrc] 20:06:00,030 DEBUG sax:1318 - startElement(,jasperReport,jasperReport) [jrc] 20:06:00,046 DEBUG Digester:1325 - Pushing body text '' [jrc] 20:06:00,046 DEBUG Digester:1344 - New match='jasperReport' [jrc] 20:06:00,046 DEBUG Digester:1359 - Fire begin() for FactoryCreateRule[className=net.sf.jasperreports.engine.xml.JasperDesignFactory, attributeName=null] [jrc] 20:06:00,046 DEBUG Digester:486 - [FactoryCreateRule]{jasperReport} New factory net.sf.jasperreports.engine.xml.JasperDesignFactory [jrc] 20:06:00,046 ERROR Digester:1363 - Begin event threw exception [jrc] java.lang.ClassNotFoundException: net.sf.jasperreports.engine.xml.JasperDesignFactory Post Edited by Prasanna Kothandaraman at 04/16/09 12:29

Hi, We have a requirement to process millions of records and generated a report. Since the size of report would be very large - we would like to get splitted into multiple reports while generating itself (say - max size of an report is 2 MB). Please let us know is it possible using Jasper. Regards, Prasanna

I am too facing this error very often. Can someone help me.

Hi all, We are getting the following exception when we use Hibernate entity. net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : ptyName Caused by: net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : ptyName Caused by: java.lang.NoSuchMethodException: Unknown property 'ptyName' When we use oridinary Java Beans, its working very fine. Here the scenarion 1. We are using Java Bean Data Source. 2. One simple Java Bean used. 3. One Hibernate entity is used. Simple Java Bean: public class Person implements Serializable{ private String name =""; private int age =0; private String subReportName="subreport"; private String recId; public String getSubReportName() { return subReportName; } public String getRecId() { return recId; } public void setRecId(String recId) { this.recId = "1"; } Hibernate entity: @Table (name = "TTI_CUST_PARTY", uniqueConstraints = @UniqueConstraint(columnNames = { "ctryCode","groupId","custRecId","ptyId"})) @RefTable("TCPR") public class CustParty extends RefBaseEntity implements Serializable { @IgnoreAudit private static final long serialVersionUID = 1L; @Column (nullable = false, length=8) @KeyInfo (resourceId="groupId") private String groupId; @XmlElement(required = true) @Column (nullable = false, length=16) @KeyInfo (resourceId="custRecId") private Long custRecId; When the Jasper reports access the fields from Class "Person", it works very. But when it access the fields from Class "CustParty", it throws error as given below. Please help us. Thanks, Prasanna t.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : ptyName at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:635) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:344) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:346) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:305) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:801) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:517) at com.scb.common.service.JasperReportManagerImpl.generateReport(JasperReportManagerImpl.java:271) at com.scb.common.service.JasperReportManagerImpl.generateDetailedReport(JasperReportManagerImpl.java:152) at com.scb.test.common.report.JasperReportsUnitTest.testGenerateDetailedReport(JasperReportsUnitTest.java:102) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99) at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34) at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75) at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45) at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66) at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35) at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34) at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) Caused by: net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : ptyName at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:127) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:100) at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:787) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:751) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1422) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:801) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:536) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209) at java.lang.Thread.run(Thread.java:619) Caused by: java.lang.NoSuchMethodException: Unknown property 'ptyName' at org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1122) at org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:686) at org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:715) at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:290) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:115) [file name=TTIX000Detailed_SinglePage.jrxml size=10763] [file name=TTIX000Detailed_SinglePage.jrxml size=10763]