Sqoop could not load db driver class

Question

I am trying to connect postgres with sqoop

Sqoop version 1.4.6-cdh5.14.2

With command

sqoop list-tables --connect jdbc:postgresql://120.4.99.798:portnumber/db --driver org.postgresql.Driver --connection-manager org.apache.sqoop.manager.GenericJdbcManager --username user --password p

But I am getting

could not load db driver class org.apache.Driver error

But JDBC jar is present in /var/lib/sqoop2

Comments

The command looks good. Download the driver again and try again. In my case, I was facing this error because the driver was corrupted.

Answer 1

Hello,

Have you tried to put the both versions of the jar in the /var/lib/sqoop2, one with java version in the name and one without ?

I have them like this in my sqoop folder.

Ex:

postgresql-42.1.4.jar

postgresql-42.1.4.jre8.jar

Also check if you are using sqoop2 and not sqoop1.