Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop2 + HUE + Oracle DB configuration

Solved Go to solution

Sqoop2 + HUE + Oracle DB configuration

Rising Star

Hi dear experts!

i'm strugling with configuring sqoop2+hue(3.7)+Oracle DB.

i'm trying to create connection in HUE, but getting error:

2015-11-06 11-04-08 Скриншот экрана.png

 

 

i have ojdbc6.jar in /var/lib/sqoop2/ dirrectory (as hinted some forums):

[root@sqoop2server ~]# ll /var/lib/sqoop2/
total 7684
-rw-r--r-- 1 sqoop2 sqoop 2677451 Nov 6 12:46 derby-10.8.2.2.jar
-rw-r--r-- 1 sqoop2 sqoop2 960396 Nov 6 13:39 mysql-connector-java.jar
-rw-r--r-- 1 root root 3670975 Nov 6 13:52 ojdbc6.jar
-rw-r--r-- 1 sqoop2 sqoop2 539705 Nov 6 13:39 postgresql-9.0-801.jdbc4.jar
drwxr-xr-x 3 sqoop2 sqoop2 4096 Nov 5 21:17 repository
drwxr-xr-x 3 sqoop2 sqoop2 4096 Nov 2 19:06 repositoy
drwxr-xr-x 5 sqoop2 sqoop 4096 Nov 6 13:39 tomcat-deployment

 

+ another one question is the any way to config Oraoop sqoop with Hue?

 

thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Sqoop2 + HUE + Oracle DB configuration

Cloudera Employee
When Sqoop2 starts, it copies /usr/share/java/oracle-connector-java.jar to /var/lib/sqoop2/. Please rename ojdbc6.jar to oracle-connector-java.jar, change the owner and group to sqoop2 and restart Sqoop2. Also, please use oracle.jdbc.OracleDriver as the JDBC Driver Class.
1 REPLY 1

Re: Sqoop2 + HUE + Oracle DB configuration

Cloudera Employee
When Sqoop2 starts, it copies /usr/share/java/oracle-connector-java.jar to /var/lib/sqoop2/. Please rename ojdbc6.jar to oracle-connector-java.jar, change the owner and group to sqoop2 and restart Sqoop2. Also, please use oracle.jdbc.OracleDriver as the JDBC Driver Class.