facebook

Report accessible via java application

  1. MyEclipse Archived
  2.  > 
  3. MyEclipse Reports
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #306872 Reply

    Srinivasa Ragavan
    Participant

    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.

    #306888 Reply

    Srinivasa Ragavan
    Participant

    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.

    #307132 Reply

    Tom McCobb
    Participant

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

    #307145 Reply

    Tom McCobb
    Participant

    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.

    #307588 Reply

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

Viewing 5 posts - 1 through 5 (of 5 total)
Reply To: Report accessible via java application

You must be logged in to post in the forum log in