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.

 

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi Anonymous 

     

    Glad that your query got resolved and thank you for sharing the details in the community as it can be helpful to others, much appreciated.

    Please continue using Fabric Community for any help regarding your queries.

     

    Thanks.

  • Rodrivieiras's avatar
    Rodrivieiras
    Icon for Helper I rankHelper I
    2 years ago

    Hello Anonymous 

     

    Are you using On-premise Oracle? I tried your solution but it is still failing. 

     

    Py4JJavaError: An error occurred while calling o4896.load. : java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)