Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Mysql connection
Mysql connection [message #724003] Sat, 10 September 2011 06:06 Go to next message
rosario portoghese is currently offline rosario portoghese
Messages: 14
Registered: April 2011
Junior Member
Hi
I have a report based on Mysql DB; the datasource is selected by:

Driver Class: com.mysql.jdbc.Driver (ff v5.1)
Driver URL: jdbc:mysql:\\localhost:3306/mysql
User Name: root
Password:

From ReportDesign everythink works well.

If I try to view my report in Tomcamt with the URL:
http:\\localhost:8080\WebViewerExample/frameset?__report=prova_web.rptdesign

the connectio to DB fails and the log file reports:

org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: DriverClassLoader failed to load class: com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Can anyone suggest some way to understand what happen and how to solve it?

Thanks
Portos
Re: Mysql connection [message #724566 is a reply to message #724003] Mon, 12 September 2011 10:54 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Do you have the MySql driver deployed to the viewer?
http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php#install_jdbc

Jason


On 9/10/2011 6:06 AM, rosario portoghese wrote:
> Hi I have a report based on Mysql DB; the datasource is selected by:
> Driver Class: com.mysql.jdbc.Driver (ff v5.1)
> Driver URL: jdbc:mysql:\\localhost:3306/mysql
> User Name: root
> Password:
> From ReportDesign everythink works well.
>
> If I try to view my report in Tomcamt with the URL:
> http:\\localhost:8080\WebViewerExample/frameset?__report=prova_web.rptdesign
>
>
> the connectio to DB fails and the log file reports:
>
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
> SEVERE: DriverClassLoader failed to load class: com.mysql.jdbc.Driver
> java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
>
> Can anyone suggest some way to understand what happen and how to solve it?
>
> Thanks
> Portos
Re: Mysql connection [message #724618 is a reply to message #724566] Mon, 12 September 2011 12:46 Go to previous message
John Roberts is currently offline John Roberts
Messages: 18
Registered: August 2011
Junior Member
You should also be able to place it in the classpath under project properties -> report design -> classpath
Previous Topic:NullPointerException registering extensions
Next Topic:Report Preview Problems in Eclipse Designer 3.7
Goto Forum:
  


Current Time: Sat Aug 30 10:24:58 EDT 2014

Powered by FUDForum. Page generated in 0.10690 seconds