Sqoop java lang RuntimeException Could not load db driver class com mysql jdbc Driver

Question

I have a create a SQL table and I am trying to import it in Sqoop. But when I run sqoop import command, I am getting the following error:

Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver

Answer 1

Seems like you don't have MySQL connector installed on your system. To make sqoop interact with MySQL, you have to install MySQL connector. You can install the drivers using the following command:

sudo apt-get install mysql-connector-java*

Answer 2

Hi,

It seems you did not copy the mysql-connector jar file. You just download it and paste it to the sqoop/lib folder.

It will work.

Thanks

Answer 3

I add mysql driver for sqoop and it running :

$ sudo cp mysql-connector-java-version/mysql-connector-java-version-bin.jar /var/lib/sqoop/

Download :  http://www.mysql.com/downloads/connector/j/5.1.html

Reference: https://docs.cloudera.com/documentation/enterprise/5-4-x/topics/cdh_ig_jdbc_driver_install.html