Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Trying to connect to an Oracle database

I'm trying to connect to an oracle database with a notebook, but I'm receive a driver error. With the Dataflow the connection is working.       %load_new_custom_jar {mssparkutils.nbResPath}/bui...
data engineering
Data Integration
  • Anonymous's avatar
    Anonymous
    2 years ago

    I solve that problem with this way.

    Upload the .jar to a folder on the Lake

     

    Go to Workspace settings > Data Engineering/Science > Spark settings > Environment.

    Create a default environment

    In the value field, put the address to the .jar 

     

    And don't forget to change the environment on the notebook.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I solve that problem with this way.

Upload the .jar to a folder on the Lake

 

Go to Workspace settings > Data Engineering/Science > Spark settings > Environment.

Create a default environment

In the value field, put the address to the .jar 

 

And don't forget to change the environment on the notebook.