clshafer Posted October 21, 2012 Share Posted October 21, 2012 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_warehouseWhen I test the connection, I get the following error: Reason: java.lang.ClassNotFoundException:com.mysql.jdbc.DriverCan you help me? Link to comment Share on other sites More sharing options...
Solution mgeise Posted October 22, 2012 Solution Share Posted October 22, 2012 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. Link to comment Share on other sites More sharing options...
clshafer Posted October 23, 2012 Author Share Posted October 23, 2012 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. Link to comment Share on other sites More sharing options...
clshafer Posted October 23, 2012 Author Share Posted October 23, 2012 found it. Thank you!!! Link to comment Share on other sites More sharing options...
day7 Posted August 22, 2013 Share Posted August 22, 2013 FYI the DataAdapter Wizard has a tab where the path to the driver jar file is entered Link to comment Share on other sites More sharing options...
john.v.little Posted August 28, 2014 Share Posted August 28, 2014 I have been unable to find the mysql jdbc driver jar anywhere. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now