|
| Re: BIRT Engine cannot find ODA dataSource [message #901066 is a reply to message #900902] |
Thu, 09 August 2012 15:26   |
|
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 15:06 |
 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 15: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 17:06 |
|
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
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.01295 seconds
] 
Search
Help
Register
Login
Home
