Eclipse Community Forums: BIRT » BIRT Engine cannot find ODA dataSource

Home » Archived » BIRT » BIRT Engine cannot find ODA dataSource

BIRT Engine cannot find ODA dataSource [message #900902]

Wed, 08 August 2012 18:20

Eclipse User

I am trying to deploy some reports developed with Eclipse BIRT Designer 4.2.0 to the sample application that came with the open source BIRT viewer (also version 4.2.0) which I have installed as "birt-viewer" on a Tomcat 6 server running on Ubuntu 9.10. The report designs employ a data connection to an instance of MySQL 5.1 also running on the same Ubuntu server.

The reports work perfectly in the Eclipse environment but when testing these reports on the server I get errors that suggest... "Cannot find the ODA dataSource extension (com.mysql.jdbc.Driver)"

I am installing the reports to $CATALINA_HOME/webapps/birt-viewer/reports, using this URI to execute...
http://[server]:8080/birt-viewer/run?__report=report/report001.rptdesign

I have copied the JDBC driver from the eclipse installation to the server at $CATALINA_HOME/webapps/birt-viewer/WEB-INF/lib.

The error makes me think there is a classpath issue, but I can't find any documentation or posting that tells me to do anything different from what I am already doing. Can someone point out what I am obviously missing?

Thanks

Nigel

Re: BIRT Engine cannot find ODA dataSource [message #901066 is a reply to message #900902]

Thu, 09 August 2012 11:26

Eclipse User

Nigel,

What jar did you copy to the web-inf/lib? Is the jar in the classpath
twice?

Jason

On 8/8/2012 6:20 PM, Nigel Deans wrote:
> I am trying to deploy some reports developed with Eclipse BIRT Designer
> 4.2.0 to the sample application that came with the open source BIRT
> viewer (also version 4.2.0) which I have installed as "birt-viewer" on a
> Tomcat 6 server running on Ubuntu 9.10. The report designs employ a data
> connection to an instance of MySQL 5.1 also running on the same Ubuntu
> server.
>
> The reports work perfectly in the Eclipse environment but when testing
> these reports on the server I get errors that suggest... "Cannot find
> the ODA dataSource extension (com.mysql.jdbc.Driver)"
> I am installing the reports to
> $CATALINA_HOME/webapps/birt-viewer/reports, using this URI to execute...
> http://[server]:8080/birt-viewer/run?__report=report/report001.rptdesign
>
> I have copied the JDBC driver from the eclipse installation to the
> server at $CATALINA_HOME/webapps/birt-viewer/WEB-INF/lib.
>
> The error makes me think there is a classpath issue, but I can't find
> any documentation or posting that tells me to do anything different from
> what I am already doing. Can someone point out what I am obviously missing?
>
> Thanks
>
> Nigel
>

Re: BIRT Engine cannot find ODA dataSource [message #901274 is a reply to message #901066]

Fri, 10 August 2012 11:06

Eclipse User

Hi Jason,

Thanks for responding to this. I copied the mysql-connector-java-5.1.13-bin.jar file to the WEB-INF/lib. That file doesn't exist anywhere else so I can assume it's not in the classpath more than once.

Here's the entire error minus the Tomcat dump...

Table (id = 9):
+ An exception occurred during processing. Please see the following message for details:
Cannot find or process the com.mysql.jdbc.Driver driver's data source extension configuration.
Cannot find the ODA dataSource extension (com.mysql.jdbc.Driver).
Check the workspace log file for any problems with loading the extension bundle and its dependencies. (Element ID:9)

I've attached the report design... it's really just a simple test report to pilot what we're trying to do.

Nigel

Attachment: MantisIssuesList-003.rptdesign
(Size: 10.99KB, Downloaded 355 times)

[Updated on: Fri, 10 August 2012 11:07] by Moderator

Re: BIRT Engine cannot find ODA dataSource [message #901621 is a reply to message #901274]

Mon, 13 August 2012 13:06

Eclipse User

Nigel

I do not have tomcat 5.1 but I tried it with 5.5 and it worked for me.
I am using 5.0.4 of the mysql driver. Do you have any other versions of
the jar in the classpath? Try to remove the one you copied to
web-inf/lib and see if it fails with the same error? BTW can you also
just run a report that uses the classic models db as a test as well?

Jason

On 8/10/2012 11:06 AM, Nigel Deans wrote:
> Hi Jason,
>
> Thanks for responding to this. I copied the mysql-connector-java-5.1.13-bin.jar file to the WEB-INF/lib. That file doesn't exist anywhere else so I can assume it's not in the classpath more than once.
>
> Here's the entire error minus the Tomcat dump...
>
> Table (id = 9):
> + An exception occurred during processing. Please see the following message for details:
> Cannot find or process the com.mysql.jdbc.Driver driver's data source extension configuration.
> Cannot find the ODA dataSource extension (com.mysql.jdbc.Driver).
> Check the workspace log file for any problems with loading the extension bundle and its dependencies. (Element ID:9)
>
> I've attached the report design... it's really just a simple test report to pilot what we're trying to do.
>
> Nigel
>
>

Previous Topic:	A problem about the web application of Birt and Tapestry
Next Topic:	Unable to connect to DB with deployed report

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 08:21:40 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter