Oozie cant able to find JDBC drivers in Sqoop

Question

Refrence to the previously asked question Oozie + Sqoop: JDBC Driver Jar Location 1 but not able to find jar in HDFS /user/oozie/share/lib/sqoop location.

I have also tried to put driver jars at my workFlow app Lib. Still Drivers not found error occure.

Answer 1

You need to add all lib files like jdbc drivers, etc in the oozie share lib folder inside sqoop folder .

This should resolve your issue.

To check the library files invoked/used by the job , go to the job tracker for the corresponding job and in syslogs you will see which all jars has been used.

Answer 2

The exact problem was the single coats "'". Because of single coats oozie take it as a single string. But it was working fine when I was using it in the Sqoop command.

................. --driver com.microsoft.sqlserver.jdbc.SQLServer...................

instead of.

.................. --driver 'com.microsoft.sqlserver.jdbc.SQLServer'................