Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
warren_marsha_talend
Contributor
Contributor

Configuring Talend for Windows 10 - JDBC Driver Error Message While Connnecting to MySQL

Hi - I'm having an issue with configuring Talend so that it recognizes the MySQL database I created. I'm receiving a JDBC driver error message. See error message below... ------------------------------------------------------------------------------------- Connection failure. You must change the Database Settings. java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:204) at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1139) at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315) at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290) at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4189) at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1) at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77) at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:124) at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:149) ... 9 more

Labels (2)
2 Replies
Anonymous
Not applicable

 

If you are using older version of mysql ar the driver classname should be  com.mysql.jdbc.Driver 

 

With latest mysql-connector-8.jar driver-class name changed to com.mysql.cj.jdbc.Driver 

warren_marsha_talend
Contributor
Contributor
Author

Where is the com.mysql.cj.jdbc.Driver located? Or where should it be placed? WIthin Talend 'Preferences' or in a java location on my local drive?