IBM Support

CLOUD: How to add JDBC drivers for use with Sqoop

Troubleshooting


Problem

If you attempt to perform a sqoop action without the appropriate jdbc drivers accessible to sqoop; you will receive an error similar to the following: ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.ibm.db2.jcc.DB2Driver OR ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver OR ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver To resolve this error, the common procedure is to add the vendor jdbc jars to the sqoop lib path. However, within cloud, root access is not provided therefore a different method is needed . The following is an example using Oracle thin client which can be adapted for whatever vendor you may be using.

[{"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Open Source Tools","Platform":[{"code":"PF016","label":"Linux"}],"Version":"4.1.0;4.2.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
18 July 2020

UID

swg21989078

Page Feedback