Cloudera Community
pranade-390330452
user rank
Visitor
My Accepted Solutions
Show All

Re: java.lang.RuntimeException: Could not load db ...

by Visitor in Support Questions
‎09-21-2014 11:46 AM
‎09-21-2014 11:46 AM
all,  I found a solution and here it is    If parcels are used then copy oracle jdbc driver to /opt/cloudera/parcels/CDH/lib/sqoop/lib   Copying ojdbc5.jar to /opt/cloudera/parcels/CDH/lib/sqoop/lib resolved my issue   Thanks, Prakash   ... View more

java.lang.RuntimeException: Could not load db driv...

by Visitor in Support Questions
‎09-20-2014 01:39 PM
‎09-20-2014 01:39 PM
Hi, I am testing loading oracle tables into hdfs/hadoop/hive with the following command   sqoop import --connect jdbc:oracle:thin:@<host>:<port>/<db>--username <user name> -P --table <TABLE>   i have copied ojdbc5.jar and ojdbc6.jar files in /usr/lib/sqoop/lib/ on the node from where I am running SQOOP.   I am getting the following error   java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver   I also tried    export SQOOP_CLASSPATH=/usr/lib/sqoop/lib/*   any ideas...?   thanks ... View more
Contact Me
Online
Offline
Last Visited
‎09-21-2014 03:06 PM
Community Statistics
Member Since ‎09-20-2014 01:39 PM
Last Visited ‎09-21-2014 03:06 PM
Posts 2