<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>
                                <td>
                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
BIRT Integration-Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda)
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/mbaxley">Mike Baxley</a> in <i>JBoss Tools</i> - <a href="http://community.jboss.org/message/610705#610705">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I created a Seam 2.2 + JBoss BIRT Integeration project (BIRT2.6).  I want to use the Hibernate ODA datasource for my reporting.  </p><p>In my test project I used the Birt Sample Classic Models database.  I generated the entity bean for the employees table and then built a report design using the Hibernate ODS datasource and dataset.  I was able to preview the data and report within the eclipse IDE.</p><p>When I run the application in JBoss 5.1, I can successfully run the test and test1 sample reports added with birt integration.  I can also view the data witht the seam generated web pages.  So it seems my birt installation works fine along with my hibernate entity manager.</p><p>When I try to run my report that uses the Hibernate ODA datasource i get the following message:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The following items have errors:</p><p>  </p><p>Table (id = 9):</p><p>+ An exception occurred during processing. Please see the following message for details:</p><p>Cannot find or process the org.jboss.tools.birt.oda driver's data source extension configuration.</p><p>Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda).</p><p> Check the workspace log file for any problems with loading the extension bundle and its dependencies. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The ReportEngine log shows this:</p><p>Jun 16, 2011 11:20:43 AM org.eclipse.birt.data.engine.odaconsumer.Driver doGetDriverManifest</p><p>SEVERE: Cannot find or process the ODA data source extension configuration.</p><p>java.lang.IllegalArgumentException: Cannot find the ODA dataSource extension (org.jboss.tools.birt.oda).</p><p> Check the workspace log file for any problems with loading the extension bundle and its dependencies.</p><p>          at org.eclipse.datatools.connectivity.oda.util.manifest.ManifestExplorer.getExtensionManifest(ManifestExplorer.java:200)</p><p>          at org.eclipse.birt.data.engine.odaconsumer.Driver.doGetDriverManifest(Driver.java:150)</p><p>          at org.eclipse.birt.data.engine.odaconsumer.Driver.findDataSourceExtensionConfig(Driver.java:126)</p><p>          at org.eclipse.birt.data.engine.odaconsumer.Driver.getDriverExtensionConfig(Driver.java:78)</p><p>          at org.eclipse.birt.data.engine.odaconsumer.Driver.getExtensionConfig(Driver.java:60)</p><p>          at org.eclipse.birt.data.engine.odaconsumer.Driver.createNewDriverHelper(Driver.java:97)</p><p>          at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getDriverHelper(DriverManager.java:111)</p><p>          at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getNewDriverHelper(DriverManager.java:100)</p><p>          at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:150)</p><p>          at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)</p><p>          at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I grabbed the source code for ManifestExplorer and added some logging.  It looks like the hibernate oda plugin is not being found.  These are the plugins that are returned from the ExtensionRegistry:</p><p>org.eclipse.birt.report.data.oda.jdbc.dbprofile</p><p>org.eclipse.birt.report.data.oda.jdbc</p><p>org.eclipse.birt.report.data.oda.sampledb</p><p>org.eclipse.birt.report.data.oda.xml</p><p>org.eclipse.datatools.connectivity.oda.flatfile</p><p>org.eclipse.datatools.enablement.oda.ws</p><p>org.eclipse.datatools.enablement.oda.xml</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>org.jboss.tools.birt.oda is not listed.  I do have the org.jboss.tools.birt.oda_1.2.0.v20110215-1225-H29-GA plugin in my plugins folder.  I have tried using it both in a jar and exploded.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Any thoughts on how to make BIRT recognize the plugin?  I also tried these same steps with my actual database with the identical results.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/610705#610705">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in JBoss Tools at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2128">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>