how to install ojbdc8 on the cluster

[GovardhanReddy]

I am trying to load data from AWS RDS oracle database to data bricks. While i am trying to read the tables from that DB in data bricks and getting error message "Class Not Found Exception". and i am not able to install driver on cluster. So, help me to install the driver on cluster.

Thanks in Advance!!

[Renu_ · Accepted solution]

Hi @GovardhanReddy, as per my understanding, you're encountering the Class Not Found Exception  because the Oracle JDBC driver is not installed on your Databricks cluster. To resolve this, you can follow these steps:

• Download the Oracle JDBC driver
• Upload the driver JAR to your Databricks workspace
• Install the driver on your cluster: Go to Clusters > Libraries > Install New, and choose the Workspace files/Volumes option based on where you uploaded the JAR file.

Once installed, you should be able to read data from the Oracle database using JDBC connection options.