I recently posted that a problem exists when I use Firebird and Jasper Reports with sub
reports.

It appears the master report has a query open, then the sub report performs a query, but
when the master report query continues processing the result set, a result set is closed
error occurs.

Is is possible to have the result set fetch all the records from the database when
st.executeQuery() is used? would this prevent the error? any thoughts?

The following error is reported:

org.firebirdsql.jdbc.FBSQLException: The result set is closed
at org.firebirdsql.jdbc.FBResultSet.checkCursorMove(FBResultSet.java:217)
at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:249)
at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:
92)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1210)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:130)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:953)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:781)
at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:427)
at java.lang.Thread.run(Thread.java:595)

NESTED BY :
net.sf.jasperreports.engine.JRException: Unable to get next record.
at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:
96)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1210)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:130)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:953)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:781)
at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:427)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.firebirdsql.jdbc.FBSQLException: The result set is closed