Forum Discussion

Rodrivieiras's avatar
Rodrivieiras
Helper I
2 years ago

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:     !...
data science
one lake
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello Rodrivieiras ,

Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

  • Rodrivieiras's avatar
    Rodrivieiras
    Helper I
    2 years ago

    Ok, I'll wait for your next reply.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.

      • Rodrivieiras's avatar
        Rodrivieiras
        Helper I
        2 years ago

        Thanks for the suggestions.

         

        I'll try them out and let you know if they work.