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

[Mark Nuttall (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBIDE-4149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mark Nuttall updated JBIDE-4149:
--------------------------------

    Attachment: new_report.zip


I have attached the ddl, the report and the exception. Unfortunately, the exception was not generated to a log file (i KNOW there was one yesterday) so i had to cut and paste from the report. So it didn't transfer well at all. Sorry.

I currently have the report set up to use the same datasource and thus it will fail after the second call to the sub report. 

> 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
>         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