TIBCO Jaspersoft® Studio JDBC connection to MySQL - Failed

Issue Description

You may experience the following exception when you have JDBC connections from TIBCO Jaspersoft® Studio v6.2.0 to MySQL

One might be working but another might fail. Both are created in Jasper Studio v6.2.0.  If you delete one of them, the other might fail as well.

Exception:

if you want to see more information look into details

Reason:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by net.sf.jasperreports_6.2.0.final 

Resolution

Explicitely add the location of the mysql driver jar in the tab Driver Classpath located at the bottom of the Data Adapter, Database JDBC Connection dialog.


Ref. Case 00066601

Feedback
randomness