ClassNotFoundException: org.postgresql.Driver

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
1

Getting this error when running Step 2.3 in the Jupyter notebook:

py4j.protocol.Py4JJavaError: An error occurred while calling o100.jdbc.
: java.lang.ClassNotFoundException: org.postgresql.Driver
at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:445)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:592)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:525)
at org.apache.spark.sql.execution.datasources.jdbc.DriverRegistry$.register(DriverRegistry.scala:46)
at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.$anonfun$driverClass$1(JDBCOptions.scala:10

2

Update: still not sure what caused the error, but I restarted the kernel and re-ran cells and it’s now working.