Sqoop:could not load DB driver Class:com.microsoft.sqlserver.jdbc.SQLServerDriver

Sqoop VERSION:1.4.6-CDH

Hadoop version:2.6.0-cdh5.8.2

Scenario: Using Sqoop to guide data from MSSQLServer

Although 1.4.6 's official website says

Even if Sqoop supports a database internally, you could still need to install the database vendor's JDBC driver in your path on your client. Sqoop can load classes from all jars in on the client and would use them as part of any $SQOOP_HOME/lib MapReduce jobs it runs; Unlik E older versions, you no longer need to install JDBC jars in the Hadoop library path on your servers.

I've put Sqljdbc4.jar under $SQOOP _home/lib , but I'm still going to make a mistake.

Could not load DB driver class:com.microsoft.sqlserver.jdbc.SQLServerDriverjava.lang.RuntimeException:Could not load DB Driver Class:com.microsoft.sqlserver.jdbc.SQLServerDriver

Try to put it under $HADOOP _home/lib , still not working;

Finally put in $HADOOP _home/share/hadoop/common/lib OK.

Sqoop:could not load DB driver Class:com.microsoft.sqlserver.jdbc.SQLServerDriver