Unable to get next record from result set

[nelangumaran]

I am getting this error

ERROR org.springframework.jms.listener.DefaultMessageListenerContainer#0-1 JRFillSubreport.prepare(864) - Fill 1: exception

net.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?

[hozawa]

JDBC connection is being closed after the first fetch. Try it with Jaspersoft Studio because iReport is no longer supported. Also, check your Oracle connection settings.