My Oracle Support Banner

Oracle Direct Connector for Hadoop Distributed File System (HDFS) HADOOP_CLASSPATH setting for JDBC (Doc ID 1405663.1)

Last updated on APRIL 02, 2019

Applies to:

Oracle Loader for Hadoop - Version and later
Information in this document applies to any platform.


According to the "Publishing the HDFS Data Paths" section of the
Oracle Direct Connector for Hadoop Distributed File System documentation
the syntax for the ExternalTable command is:

bin/hadoop jar orahdfs.jar oracle.hadoop.hdfs.exttab.ExternalTable [-conf config_file | -D property=value] -publish [-noexecute]

However executing the command:

hadoop jar orahdfs.jar oracle.hadoop.hdfs.exttab.ExternalTable -conf <confFile> -publish

may raise:

Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource
at oracle.hadoop.hdfs.exttab.ExternalTable.getConnection(
at oracle.hadoop.hdfs.exttab.ExternalTable.publish(
at oracle.hadoop.hdfs.exttab.ExternalTable.main(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at org.apache.hadoop.util.RunJar.main(
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.pool.OracleDataSource
at Method)
at java.lang.ClassLoader.loadClass(
at java.lang.ClassLoader.loadClass(

indicating that the Oracle Direct Connector for Hadoop Distributed File System (HDFS) is unable to make a JDBC connection.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.