Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT Engine cannot find ODA dataSource
BIRT Engine cannot find ODA dataSource [message #900902] Wed, 08 August 2012 18:20 Go to next message
Nigel Deans is currently offline Nigel Deans
Messages: 2
Registered: August 2012
Junior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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
>


Jason Weathersby

BIRT Exchange
Re: BIRT Engine cannot find ODA dataSource [message #901274 is a reply to message #901066] Fri, 10 August 2012 11:06 Go to previous messageGo to next message
Nigel Deans is currently offline Nigel Deans
Messages: 2
Registered: August 2012
Junior Member
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

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

Report message to a moderator

Re: BIRT Engine cannot find ODA dataSource [message #901621 is a reply to message #901274] Mon, 13 August 2012 13:06 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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


Jason Weathersby

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


Current Time: Fri Apr 25 02:59:04 EDT 2014

Powered by FUDForum. Page generated in 0.01641 seconds