question Re: java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver in Archives of Support Questions (Read Only)

java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver

pranade-390330452 — Fri, 16 Sep 2022 09:08:04 GMT

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

Re: java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver

abe — Sat, 20 Sep 2014 22:15:13 GMT

Hey there,

What java version are you running? ojdbc5.jar should be for JDK 1.5 and ojdbc6.jar should be for JDK 1.6. Choose the jar appropriately.

If the above doesn't work, you should be able to add a "--verbose" flag after "import" in the command you've provided to see the classpaths being used.

Re: java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver

pranade-390330452 — Sun, 21 Sep 2014 18:46:07 GMT

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