[jbosstools-issues] [JBoss JIRA] Commented: (JBIDE-4149) Hibernate ODA errors on subreport on subsequent calls to Dataset

[Snjezana Peco (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBIDE-4149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12467986#action_12467986 ] 

Snjezana Peco commented on JBIDE-4149:
--------------------------------------

The fix doesn't change behavior. I think it can be committed to the 3.0.x branch.
The issue was related to the session factory. It was nullify when closing a result set. That's why more than one result set didn't work correctly in the report.
Now, a result set opens and closes the session. Session factory is created if necessary (if it isn't already created with Hibernate, Seam or with some other Birt session) and never closed. Seam Generate Entities works in a similar way. The difference is that Seam always creates (builds) a new session factory. 

> Hibernate ODA errors on subreport on subsequent calls to Dataset
> ----------------------------------------------------------------
>
>                 Key: JBIDE-4149
>                 URL: https://jira.jboss.org/jira/browse/JBIDE-4149
>             Project: Tools (JBoss Tools)
>          Issue Type: Bug
>          Components: birt
>    Affects Versions: 3.0.0.GA
>            Reporter: Mark Nuttall
>            Assignee: Snjezana Peco
>             Fix For: 3.1.0.M1
>
>         Attachments: new_report.zip
>
>
> When using Hibernate ODA in a BIRT report for a subreport, an exception occurs when the dataset is called for a second time.  It seems to be expecting the connection to be open and it isn't or it is open and it expects it to be closed.  I am pretty sure the exception i saw was that it tried to open the connection.
> If i use a single datasource with 2 datasets, then the report errors out after the second call to the subreport. For example:
> Customer: Bob Smith
>    Order 1
>    Order 2
> Customer: Jane Doe
> [Exception]
> If I use 2 datasources and a single dataset each then the report runs to completion and the exception is shown at the end. Only the first parent will have children though. For example:
> Customer: Bob Smith
>    Order 1
>    Order 2
> Customer: Jane Doe
> Customer: Joe Schmo
> Customer: Roger Dodger
> Customer: Rick James
> [Exception]

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira