Birt - data from external database

adam_bo_ — Sun, 08 Jun 2014 09:07:29 GMT

How to connect to external database in a Birt report runned in nuxeo ? Definitions included in *.rptdesign files are ignored and BirtEngine connects only to Nuxeo database.

Best regards Adam

Re: Birt - data from external database

adam_bo_ — Wed, 11 Jun 2014 06:48:26 GMT

In the method getNuxeoReport of the class ReportHelper it should be included:

for (Iterator i = designHandle.getDataSources().iterator(); i.hasNext();) {
    OdaDataSourceHandle dsh = (OdaDataSourceHandle) i.next();

    (+)OdaDataSource ds = (OdaDataSource) dsh.getElement();            
    (+)Module root = ds.getRoot();
    (+)String odaJndiName = (String) ds.getProperty(root, "odaJndiName");
    (+)if (odaJndiName == null || odaJndiName.isEmpty())
    (+){
        String singleDS = Framework.getProperty(
                    "nuxeo.db.singleDataSource", null);
    if (singleDS != null && !singleDS.isEmpty()) {
        (-)OdaDataSource ds = (OdaDataSource) dsh.getElement();

This code checks if there is the "odaJndiName" property in a report and use it. Otherwise, it runs as usual.

All the best.

topic Birt - data from external database in Nuxeo Forum

Birt - data from external database

Re: Birt - data from external database