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?
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.
FYI the DataAdapter Wizard has a tab where the path to the driver jar file is entered
I have been unable to find the mysql jdbc driver jar anywhere.