Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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?