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
Highlighted

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.

View solution in original post

1 REPLY 1
Highlighted

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.

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here