title: Connecting Oracle DB from PySpark 3.1.2 - fails with Py4JJavaError
body: <p>I am trying out PySpark3.2.1 with Oracle 11G. It fails with the following error:</p>
  <pre><code>Py4JJavaError: An error occurred while calling o44.load.
  : java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
      at java.net.URLClassLoader$1.run(Unknown Source)
      at java.net.URLClassLoader$1.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
  </code></pre>
  <p>My code:</p>
  <pre><code>from pyspark.sql import SparkSession
  
  spark = SparkSession.builder.appName(&quot;PySpark_Oracle_Connection&quot;).getOrCreate()
  
  driver = 'oracle.jdbc.OracleDriver'
  url = 'jdbc:oracle:thin:@hostname:port/dbTEST'
  user = 'myname'
  password = 'mypswd'
  table = 'mytable'
  
  SPARK_CLASS_PATH = &quot;C:\Oracle_Client\jdbc\lib\ojdbc8.jar&quot;
  
  df = spark.read.format('jdbc')\
      .option('driver', driver)\
      .option('url', url)\
      .option('dbtable', table)\
      .option('user',user)\
      .option('password',password).load()
  </code></pre>
  <p>I'd appreciate a quick help, please. I have gone through previous posts, but still doesn't work.</p>