Prateek created SQOOP-2502:
------------------------------
Summary: Unable to connect to Oracle DB : Could not load db
driver class: oracle.jdbc.OracleDriver
Key: SQOOP-2502
URL: https://issues.apache.org/jira/browse/SQOOP-2502
Project: Sqoop
Issue Type: Test
Components: connectors/oracle
Affects Versions: 1.4.5
Environment: CentOS 6.6 , HDP 2.2.6
Reporter: Prateek
Priority: Blocker
Hi ,
I am trying to connect to the Oracle DB server.
I have placed the ojdbc6.jar in the lib directory and given 755 permission to
that.
Still i am getting the following error -
Warning: /usr/hdp/2.2.6.0-2800/accumulo does not exist! Accumulo imports will
fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/08/18 12:45:19 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5.2.2.6.0-2800
15/08/18 12:45:19 DEBUG tool.BaseSqoopTool: Enabled debug logging.
15/08/18 12:45:19 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.
15/08/18 12:45:19 DEBUG sqoop.ConnFactory: Loaded manager factory:
org.apache.sqoop.manager.oracle.OraOopManagerFactory
15/08/18 12:45:19 DEBUG sqoop.ConnFactory: Loaded manager factory:
com.cloudera.sqoop.manager.DefaultManagerFactory
15/08/18 12:45:19 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
org.apache.sqoop.manager.oracle.OraOopManagerFactory
15/08/18 12:45:19 DEBUG oracle.OraOopManagerFactory: Data Connector for Oracle
and Hadoop can be called by Sqoop!
15/08/18 12:45:19 INFO oracle.OraOopManagerFactory: Data Connector for Oracle
and Hadoop is disabled.
15/08/18 12:45:19 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
com.cloudera.sqoop.manager.DefaultManagerFactory
15/08/18 12:45:19 DEBUG manager.DefaultManagerFactory: Trying with scheme:
jdbc:oracle:thin:@10.137.12.76
15/08/18 12:45:19 DEBUG manager.OracleManager$ConnCache: Instantiated new
connection cache.
15/08/18 12:45:19 INFO manager.SqlManager: Using default fetchSize of 1000
15/08/18 12:45:19 DEBUG sqoop.ConnFactory: Instantiated ConnManager
org.apache.sqoop.manager.OracleManager@5217e8de
15/08/18 12:45:19 ERROR sqoop.Sqoop: Got exception running Sqoop:
java.lang.RuntimeException: Could not load db driver class:
oracle.jdbc.OracleDriver
java.lang.RuntimeException: Could not load db driver class:
oracle.jdbc.OracleDriver
at
org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:286)
at
org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
