topic Re: remote database connection error in Data Engineering

remote database connection error

aarave — Thu, 06 Oct 2022 10:44:44 GMT

Hi,

I am using databricks through azure. I am trying to connect to remote oracle database using jdbc url. I am getting an error of no suitable driver found.

"java.sql.SQLException: No suitable driver"

can somebody help mw with this?

Re: remote database connection error

aarave — Fri, 07 Oct 2022 09:34:11 GMT

Class not defined error

Re: remote database connection error

aarave — Mon, 10 Oct 2022 11:13:15 GMT

the problem still stays. it doesn't speak of the driver installation on databricks

Re: remote database connection error

Hubert-Dudek — Fri, 14 Oct 2022 11:40:15 GMT

When you query JDBC, which is not MSSQL, you need to install and set the driver option.

So you need to get the JDBC driver for Oracle and install it first.

https://www.oracle.com/database/technologies/maven-central-guide.html

you need to know which one (from administrator or support=, and then in cluster config, you can install it from Maven.

driver = "your_driver_name"
 
remote_table = (spark.read
  .format("jdbc")
  .option("driver", driver)
...

Re: remote database connection error

Anonymous — Tue, 15 Nov 2022 08:47:02 GMT

Hi @vikas k

Hope all is well!

Does @Hubert Dudek response were able to resolve your issue, and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Re: remote database connection error

Debayan — Fri, 07 Oct 2022 06:07:00 GMT

Hi, @vikas k , You have to load the driver class.

Fo example:

Class.forName("com.mysql.jdbc.Driver");