[jira] [Resolved] (SQOOP-2502) Unable to connect to Oracle DB : Could not load db driver class: oracle.jdbc.OracleDriver

["Venkat Ranganathan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SQOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Venkat Ranganathan resolved SQOOP-2502.
---------------------------------------
    Resolution: Not A Problem

>  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)