Mapping result set to rewindable datasource

[dgrigglestone]

Hi .. I have a very complex (expensive) query that needs to get passed to 4 sub-reports. Since a JDBC results set is not rewindable, I'm looking for a way that I can map the JDBC result set once into a rewindable data source and then pass that to the subreports.

This sounds like something that someone else must have tried to solve before, so does anyone have a solution that can share?

[hozawa]

Yes, it does look like someone has done before.

Take a look at the following page under "rewindable data source"

http://jasperreports.sourceforge.net/sample.reference/datasource/

[dgrigglestone]

What was the explicit example you are referring to. I was aware of the section you pointed me to, but alas I do not find any rewindable datasource that can take a JDBC datasource (http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/JRResultSetDataSource.html) and map it to a rewindable datasource .. nor can I find any pointer to logic that will do so. I am looking for an explicit example. If I end up writing myself, I'll try to post back here .. but hopefully someone has real code I can reuse.