Bug 482700 - CDO ODA driver proposal for integration with BIRT
Summary: CDO ODA driver proposal for integration with BIRT
Status: NEW
Alias: None
Product: EMF
Classification: Modeling
Component: cdo.core (show other bugs)
Version: 4.13   Edit
Hardware: PC Windows 7
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-11-20 09:32 EST by Laurent Le Moux CLA
Modified: 2020-12-11 10:46 EST (History)
1 user (show)

See Also:


Attachments
model1, model1.oda and org.eclipse.emf.cdo.oda plug-ins (133.49 KB, application/x-zip-compressed)
2015-11-20 09:32 EST, Laurent Le Moux CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Laurent Le Moux CLA 2015-11-20 09:32:59 EST
Created attachment 258183 [details]
model1, model1.oda and org.eclipse.emf.cdo.oda plug-ins

Hi,

I generate BIRT reports based on my CDO repository content.
In the past, it was possible to directly use the EMF ODA driver by providing the CDO server URI.
Since CDO 4.2, this driver can not be used anymore in combination with the introduced security manager.

Therefore I implemented a basic CDO ODA driver as an extension of the EMF one. And I am willing to share it.

To run the attached example, here are the steps to follow :
1. Install EMF ODA driver SDK in your IDE
2. The example is based on model1.ecore used in the CDO wiki
3. Setup a CDO server, with content based on model1 (a resource containing a Company element)
4. Import the generic CDO ODA driver 'org.eclipse.emf.cdo.oda' in your workspace
5. Do the same with the CDO ODA driver extension 'model1.oda' (see its unique class and the extensions in plugin.xml)
6. Install BIRT framework in your IDE
7. Clone BIRT's git repository ('Mars' branch)
8. Import 'org.eclipse.birt.report.designer.ui.rcp' project as it is not part of BIRT framework
9. Add model1.oda to its plugin.xml dependencies
10. Refresh BIRT.product required plug-ins consequently
11. Launching the product in your IDE as an Eclipse application will fail (see bug 367187)
12. Therefore add Batik css, util and util.gui plug-ins in the launch configuration
13. Once BIRT Report Designer has successfully started, create a report design
14. Create a CDO data source (ping should be successfull)
15. Create a data set with 'model1::Company.allInstances()' query and 'model1.Company' result
16. After 'Finish', you can choose to preview results
17. Add a table to your report linked to the data set and select String types (Name, Street, City of Company)
18. Finally, 'view' your report...

Notes :
- The 'self' keyword is not supported in the OCL queries.
- Some copy / paste was necessary in 'org.eclipse.emf.cdo.oda' but a better integration could be achieved with slight modifications of the EMF ODA driver code...

Kind regards,

Laurent
Comment 1 Eike Stepper CLA 2016-07-31 00:54:40 EDT
Moving all unaddressed bugzillas to 4.6.
Comment 2 Eike Stepper CLA 2017-12-28 01:17:00 EST
Moving all open bugs to 4.7
Comment 3 Eike Stepper CLA 2019-11-08 02:17:20 EST
Moving all unresolved issues to version 4.8-
Comment 4 Eike Stepper CLA 2019-12-13 12:55:19 EST
Moving all unresolved issues to version 4.9
Comment 5 Eike Stepper CLA 2020-12-11 10:46:25 EST
Moving to 4.13.