I have a report with 150 columns and more than 6000 rows running with a Oracle Database View, the problem is that when I run it the following Exception is throwed: Unable to get value for field 'C1' of class 'java.lang.String' net.sf.jasperreports.engine.JRException: Unable to get value for field 'C1' of class 'java.lang.String' at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:314) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:814) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:778) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1417) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:115) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:891) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:795) 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.JasperFillManager.fillReport(JasperFillManager.java:363) at siceweb.reportes.jasper.AdministradorJasper.ejecutaReporte(AdministradorJasper.java:52) at siceweb.reportes.jasper.AdministradorJasper.AbreReporte(AdministradorJasper.java:58) at siceweb.reportes.jasper.AdministradorJasper.AbreReporte(AdministradorJasper.java:71) at siceweb.formas.MisReportes.ejecutaReporte(MisReportes.java:143) at siceweb.formas.MisReportes.onEvent(MisReportes.java:154) at org.zkoss.zk.ui.impl.EventProcessor.process0(EventProcessor.java:197) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:143) at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:483) at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:419) Caused by: java.sql.SQLException: Juego de resultados cerrado: getMetaData at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:861) at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:121) at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getMetaData(DelegatingResultSet.java:283) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:220) ... 18 more When I run it with less rows It runs OK. I tried using the JRSwapFileVirtualizer with same results. Any suggestions?
