Subreports and Jaybird - Is it possible?

[lbor]

Hi

I can't seem to get subreports working with Jaybird (jaybird-full-2.2.12.jar - see error at the bottom).

I tried creating a separate data adaptor specific for the subreport. The error dissapears but no data is displayed. Also tried to do a hardcoded query (no parameters) for the subreport, and while it displays fine in subreport preview, there's no subreport data in the main report. 

I should mention that I am able to create a subreport using the sample data adaptor (org.hsqldb.jdbcDriver), it's just the Firebird jdbc that seems to not work.

 

Anyone got this working?

---------------------

et.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Unable to get next record from result set.

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:548)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:523)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:404)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Caused by: net.sf.jasperreports.engine.JRException: Unable to get next record from result set.

at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:145)

at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1538)

at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1387)

at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1366)

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

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

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

at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123)

at java.lang.Thread.run(Thread.java:745)

Caused by: org.firebirdsql.jdbc.FBSQLException: The result set is closed

at org.firebirdsql.jdbc.AbstractResultSet.checkOpen(AbstractResultSet.java:231)

at org.firebirdsql.jdbc.AbstractResultSet.checkCursorMove(AbstractResultSet.java:220)

at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:280)

at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:141)

... 8 more

 

[lbor]

Ok, found some solutions:

 

1. Use older driver (max version 1.5.6).

2. Add defaultHoldable = true in Connection Properties for Data Adapter.

 

2) is obviously the way to go.