Forum Discussion
Fabric notebook - Oracle connection error: java.lang.ClassNotFoundException
I am trying to connect to an Oracle database, but the oracle driver is not being found by Pyspark. First I uploaded the oracle jdbc driver v.11 in the builtin folder: Code: !...
Ok, I'll wait for your next reply.
Hello Rodrivieiras ,
Apologies for the delay in reply from our side.
Please try to load the jar via the following magic:
# Load jar directly to the Scala interpreter
%load_new_custom_jar {mssparkutils.nbResPath}/builtin/Animation1.jar
Starting a new SparkSession doesn't work here. You can also drag and drop a jar file from notebook filesystem. Here's the doc: How to use notebooks - Microsoft Fabric | Microsoft Learn
Hope this is helpful. Please let me know incase of further queries.