Update query from Azure databricks to Oracle table

[bkbarunkalita64]

I need to update a single row on a on-prem Oracle table via jdbc connection.

Please note, I don't want to append, just have to update a row, is it possible ?

[Anonymous]

Hi @Tony S​ 

Great to meet you, and thanks for your question!

Let's see if your peers in the community have an answer to your question. Thanks.

[Kaniz]

Hi @Tony S​ , This article mentioned all the steps required to establish a successful connection with the database using Python.

However, you can try this code :-

df.write.format("jdbc") \
  .option("url", dbServerJdbcUrl) \
  .option("user", username) \
  .option("password", password) \
  .option("driver", "com.microsoft.sqlserver.jdbc.SQLServerDriver") \ # or "oracle.jdbc.driver.OracleDriver" for Oracle
  .option("dbtable", "your_table_name") \
  .mode('overwrite') \
  .save()

Make sure you have the necessary dependencies and libraries imported to use the write method with JDBC in PySpark.