[Srinivasa Ragavan]

Is it possible to access the report designed by myEclipse tool, through Java Application?
Does Report API or any other way available to achieve that?

In other words….
Since the reporting of myEclipse run as web application, I am not sure how to make use of existing report to be accessible through Java application. If that is possible, i would schedule the java application, which in turn call the report and run it as scheduled time.

Regards
Srini.

[Srinivasa Ragavan]

I could able to download BIRT runtime engine and run the report file as a standalone java application.
But when I tried, I am getting
java.lang.IllegalArgumentException: Cannot find the ODA dataSource extension (com.genuitec.eclipse.reporting.oda).

I believe this is because the BIRT expects ‘org.eclipse.birt.report.data.oda.jdbc_2.5.2.v20100205’ plugin to be used as I have configured the driver of that plugin with MSSQL database JDBC driver.

But I believe, the myEclipse is trying to connect ‘com.genuitec.eclipse.report.oda’ instead of eclips.birt, and hence missing JDBC driver and results the above error.

I am not sure how to disable the myeclipse ODA plugin and make use of BIRT ODA plugin.
or
I have configure myEclipse ODA with my JDBC driver.

Any suggestions please.

Regards
Srini.

[Tom McCobb]

I am having the identical problem. I need to access the BIRT engine from three separate WARs and it would be rediculous to package the BIRT/Genuitec jars with each WAR.

Notice in the report XML the following:

    <data-sources>
        <oda-data-source extensionID="com.genuitec.eclipse.reporting.oda" name="Data Source" id="7">
            <property name="meDriver">ACCData</property>
            <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
            <property name="odaURL">jdbc:mysql://localhost:3306/acc</property>
            <property name="odaUser">xxxxx</property>
            <encrypted-property name="odaPassword" encryptionID="base64">xxxxxxx</encrypted-property>
            <property name="odaJndiName">java:/jdbc/ACCDS</property>
        </oda-data-source>
    </data-sources>

and again

    <data-sets>
        <oda-data-set extensionID="com.genuitec.eclipse.reporting.oda.dataSet" name="Data Set" id="8">
            <list-property name="computedColumns">
                <structure>
                    <property name="name">totalreg</property>
                    <property name="dataType">float</property>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value">row["count(pa.person_id)"]</expression>
                        </structure>
                    </list-property>
                </structure>
....
        </oda-data-set>
    </data-sets>

If I include the com.genuitec.eclipse.reporting..oda_8.0.0.mexxxxx.jar in the BIRT viewer war directly in the plugins folder, then I get around the ODA exception, but I get some new ClassCastException errors (cannot cast double as BigDecimal).

[Tom McCobb]

The class cast errors I was getting were related to result types I had defined in some computed columns. The ME report engine didn’t complain – the Eclipse BIRT engine did.

Bottom line is they are fixable. Looks like just adding the com.genuitec.eclipse.reporting..oda_X.0.0.mexxxxx.jar into the birt.war does the trick.

[support-shalini]

tmccobb,
Thank you for the workaround.
I will also escalate this to the dev team

[Author]

Posts