Maximum open cursors exceeded in Oracle

[softexpert]

Hello, I have a problem when generating report with many registers. My report have a subreports that can be cause the problem, but I think that the problem is that the report does not close the open statments. This error only occurs with the Oracle database which limits the amount of open cursors. The limit on my database are 1000 cursors to be opened.

 

This is the error when i execute my report:

 

java.lang.RuntimeException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : project_report

           at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:663)

           at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:331)

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

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

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

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

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

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

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

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

           at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:561)

           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(Unknown Source)

Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : project_report

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

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

           at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605)

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

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

           ... 5 more

Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

 

           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

           at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:630)

           at oracle.jdbc.driver.T2CPreparedStatement.execute_for_describe(T2CPreparedStatement.java:851)

           at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)

           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)

           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)

           at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)

           at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

           at com.softexpert.sql.SEPreparedStatement.executeQuery(SEPreparedStatement.java:69)

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

           ... 9 more

 

           at com.se.report.JasperComponent.getInputStream(JasperComponent.java:56)

           at com.se.report.SEViewer.initComponents(SEViewer.java:75)

           at com.se.report.SEViewer.start(SEViewer.java:167)

           at com.se.report.SEViewer$1.run(SEViewer.java:45)

           at java.awt.event.InvocationEvent.dispatch(Unknown Source)

           at java.awt.EventQueue.dispatchEvent(Unknown Source)

           at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

           at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

           at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

           at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

           at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

      at java.awt.EventDispatchThread.run(Unknown Source)Quero saber se é possível resolver este problema.

 

 

How can I solve this problem?