Jaspersoft Studio Data Connector for MySQL

I have successfully created a data connection for iReports but I am trying to get Jaspersoft Studio working with MySQL.  Is there something special I have to do with Studio that I don't for iRerpots.  In STUDIO I clicked on the Data Adapter Wizard, clicked next,  chose "Configure Database JDBC Connection",  Entered the following for the JDBC Drive and URL.

JDBC Drive: com.mysql.jdbc.Driver
JDBC Url: jdbc:mysql://localhost/stat_warehouse

When I test the connection,  I get the following error:  Reason: java.lang.ClassNotFoundException:com.mysql.jdbc.Driver

Can you help me?




clshafer's picture
Joined: Mar 28 2012 - 4:47pm
Last seen: 9 years 2 weeks ago

1 Answer:

You need to download and add the mysql driver to the classpath of Jaspersoft Studio.  Older versions of iReport were shipped with the MySQL driver, but I don't think they are shipped with the newer versions.

mgeise's picture
Joined: Mar 5 2007 - 6:18am
Last seen: 3 years 3 months ago
I am a quite ignorant on the connectors stuff. I was able to download mysql-connector-odbc-noinstall-5.2.2-win64 folder with other folders (bin,lib,test). Is there a specific file I need to add to the classpath? or the entire folder? and where is the classpath to add this to? Thank you.
clshafer - 10 years 5 months ago
found it. Thank you!!!
clshafer - 10 years 5 months ago

FYI the DataAdapter Wizard has a tab where the path to the driver jar file is entered

day7 - 9 years 7 months ago
show 1 more...

I have been unable to find the mysql jdbc driver jar anywhere.

john.v.little - 8 years 6 months ago