[jira] Updated: (WW-3245) Jasper plugin does not support supply of data via report parameters (for example Hibernate session object)

["Andrew Hodgson (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/struts/browse/WW-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrew Hodgson updated WW-3245:
-------------------------------

    Attachment: struts2JasperReportsPluginHQLPatch.patch

Attached patch file with suggested implementation.

This achieves the result by examining the relevant report parameter "HIBERNATE_SESSION" and if present calls the correct JasperFillManager.fillReport method.

If dataSource, connection & no session supplied in the report parameters, an error is thrown as before.

It would be possible to introduce Session as a parameter to the plugin, but this would most likely introduce a dependancy between the plugin and Hibernate, which might not be desirable, hence I didn't choose this route.

> Jasper plugin does not support supply of data via report parameters (for example Hibernate session object)
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: WW-3245
>                 URL: https://issues.apache.org/struts/browse/WW-3245
>             Project: Struts 2
>          Issue Type: Improvement
>          Components: Plugin - JasperReports
>    Affects Versions: 2.1.6, 2.2.x, Future
>         Environment: Present in all environments, attempting usage of Hibernate query HQL embedded in a JasperReport.
>            Reporter: Andrew Hodgson
>            Priority: Minor
>         Attachments: struts2JasperReportsPluginHQLPatch.patch
>
>
> A typical usage scenario for a Jasper report involves writing code within the report document to retrieve report from a database recent Struts code supports this via supply of a SQL Connection object, but I notice it's not supported in 2.1.6 production release.  
> JasperReports supports many implementation languages for it's data retrieval code, but in particular I have identified issue in relation to Hibernate HQL queries.
> Normal route in this scenario (if not using Struts JasperReports plugin) is to supply Hibernate session as a parameter to the report, then implement HQL within the document to retrieve the data.  However the Plugin only supports Connection or a pre-populated dataSource as a source for the report's data.  This means a temporary data structure (perhaps a sizable List / Map) must be produced in order to present data to the Plugin..
> It would be more efficient and convenient to either support supply of a Hibernate Session object, or allow call to the plugin when both connection and datasource are absent.  In this scenario, the plugin would respond by calling 
> http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/JasperFillManager.html#fillReport(java.io.InputStream,%20java.util.Map)
> And rely on Jasper Fill Manager's inbuilt functionality to draw connection detail from the supplied parameters. This option has the advantage that it can support a range of query languages / connection methods that JasperReports may support, now or in the future.  
> The code would of course have to deal with the case in which the relevant report parameters have be left blank, and thus respond with an appropriate error condition, as it does in Struts 2.1.6  when dataSource has been left null.
> I will attempt to produce a patch with proposed modified code in the near future, to assist with this improvement.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.