nelangumaran

Hi I am generating huge report using jasper. We are using JRSwapFileVirtualizer new JRSwapFileVirtualizer(10, new JRSwapFile("directory", 2048, 1024), true) Once i triggered the report, the multiple swap files are created with 0 kb in certain interval. And each swap file takes each oracle session. 0 Feb 10 06:13 swap_829782293_14867251998010 Feb 10 06:34 swap_2052563733_14867264556240 Feb 10 06:55 swap_1512809775_14867277048950 Feb 10 07:04 swap_81603532_14867282545770 Feb 10 07:07 swap_2116103053_14867284346520 Feb 10 07:12 swap_262089995_1486728761876After 20 swap files all oracle sessions are full. So, We are unable to process with next report. Please help me how to handle this issue, why multiple swap files are creating and why swap files is not incrementing? Thanks in advance

I have two report and i deployed it in jasperreports server. As per my requirement, I have to export it in Excel format. But both report have different xls exporter properties. eg. Report1 - IgnoreGraphics= true; Report2 - IgnoreGraphics= false; Not only above the xls property also many other(one_page_per_sheet, max per sheet, etc ....) Every time i changing WEB-IN/applicationContext.xml file to generate the report in my local machine. I am unable to do this config change in WEB-IN/applicationContext.xml file for each report, in higher env(PROD). Is it possible to change the xls property dynamically based on the report ?

I have to migrate Altreyx report to Jasper. I am new to jasper and i have no idea on this. should i use Jaspersoft ETL or iReports tool for this migration?

I created a report using table like below First NameCountryAmi USJohnUKNow i have to add two more rows in the excel from another query. So, my report should like below. First NameCountryAmiUSJohnUKSteveAusKevinCanadais this possible?

I am getting this error ERROR org.springframework.jms.listener.DefaultMessageListenerContainer#0-1 JRFillSubreport.prepare(864) - Fill 1: exceptionnet.sf.jasperreports.engine.JRException: Unable to get next record from result set. at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:130) at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1422) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1271) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1250) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1003) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:120) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:551) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:728) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722)Caused by: java.sql.SQLException: Closed Connection: next at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:200) at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:126) ... 13 more Any idea on this?