Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Mysql connection
Mysql connection [message #724003] Sat, 10 September 2011 06:06 Go to next message
Eclipse UserFriend
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
Eclipse UserFriend
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
Eclipse UserFriend
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: Wed Jul 23 16:06:16 EDT 2025

Powered by FUDForum. Page generated in 0.05118 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly