XML from database

[aetherflux]

I have an XML datasource that I want to use to generate parameters... however, this datasource isn't in a file, it's in the "Parameter" column of the ReportCriteria table of the database that is currently the active JDBC connection.

 

 

Is there a way to get iReport to somehow parse this data without re-writing my code to create a new XML file every time the report is run?

[justis]

I think you would have to do some sort of strange join to that table and get it included as part of your report query. Perhaps you could have all your reports be subreports and the outer report performs the query to get your settings. Either way seems like a jury-rigged solution.

 

Most likely, your needs will be best met by building your own datasource before you fill the report. You could write a servlet (or whatever paradigm is appropriate for your environment) that queries the database twice, builds a single XML datasource (in memory, no need to spool to disk) and passes that to JasperFillManager as its datasource.

 

Best of luck.

 

Kind regards,

Justis