Bug 496524 - [Joint DataSet] inner datasets are not closed.
Summary: [Joint DataSet] inner datasets are not closed.
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 4.5.0   Edit
Hardware: PC Windows All
: P3 critical (vote)
Target Milestone: ---   Edit
Assignee: Birt-Data-inbox@eclipse.org CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-22 03:40 EDT by Nicolas FELIX CLA
Modified: 2016-07-08 02:12 EDT (History)
0 users

See Also:


Attachments
test case (3.44 KB, application/x-zip-compressed)
2016-06-22 03:40 EDT, Nicolas FELIX CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nicolas FELIX CLA 2016-06-22 03:40:41 EDT
Created attachment 262575 [details]
test case

Hi,
First of all, this is the first time I use a *Joint DataSet*, 
I thus apologize if I did something wrong.


Steps To Reproduce:
1. Create 2 datasets.
2. create a *Joint DataSet* using those" 2 Datasets.
3. Add log information on different available events (beforeOpen, afterOpen, beforeClose, afterClose).
4. DataSet Close events don't seem to be called.

Tested with Birt 4.4.2 and 4.5.0.

I attached a sample (*be careful*, absolute paths have been set to the csv datasources).
The four available events contain a _System.out.println_ call (fell free to change this as a more convenient way).

Running this report using _Birt RCP Designer_, the _command line_ or even _programmatically_ results to only the following logged lines

* opening data1Set
* opening data2Set
* data1Set opened
* data2Set opened

No information on dataset closing events.


The main (and *critical* IMHO) issue with this (if confirmed), when using real datasets (I mean targeting databases, Oracle in my environment), is this results in _too many cursor opened_ 
as my *joint dataset* is included in a table, and thus played many times (that's why the sample I provide here contains a table embedding my script dataset).


+Note+: I apologize for my poor English skill, I'am French ;-)

Any help will be appreciated.

Thanks,
Nicolas
Comment 1 Nicolas FELIX CLA 2016-07-08 02:12:40 EDT
Hi,
Is it the right place to open issue ?
any chance to have feedbacks ? at least, I wonder if this has been read by someone else ;-)