Sqoop2 + HUE + Oracle DB configuration

[#1]

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:

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!

[#2 · Accepted solution]

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.