title: connecting to auroradb with postgres jar driver local mode in pyspark
body: <p>Im trying to connect to an aurora db using a the jar file dowwnloaded locally this is my code :</p>
  <pre><code>spark = SparkSession.builder.master(&quot;local&quot;).appName(&quot;PySpark_app&quot;).config(&quot;spark.driver.memory&quot;, &quot;16g&quot;).config(&quot;spark.jars&quot;, &quot;D:/spark/jars/postgresql-42.2.5.jar&quot;)\
      .getOrCreate()
  
  spark_df = spark.read.format(&quot;jdbc&quot;).option(&quot;url&quot;, &quot;postgresql://aws-som3l1nk.us-west-2.rds.amazonaws.com&quot;) \
      .option(&quot;driver&quot;, &quot;org.postgresql.Driver&quot;).option(&quot;user&quot;, &quot;username&quot;)\
      .option(&quot;password&quot;, &quot;password&quot;).option(&quot;query&quot;,query).load()
  </code></pre>
  <p>after trying to read the data i get this error :</p>
  <pre><code>An error occurred while calling o401.load.
  : java.lang.ClassNotFoundException: org.postgresql.Driver
      at java.net.URLClassLoader.findClass(Unknown Source)...
  </code></pre>
  <p>not sure if im missing something or even if the jar file is considered or not.
  im working on a local machine on this and trying to install packages using <code>pyspark --packages</code> fail as well!</p>