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.

 

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)