topic Re: I am trying to connect to Azure Databricks SQL from my Spring Boot Application. is it possible to connect using the JDBC URL details. OR is it NOT supported yet. Please let me know. in Data Engineering

I am trying to connect to Azure Databricks SQL from my Spring Boot Application. is it possible to connect using the JDBC URL details. OR is it NOT supported yet. Please let me know.

Vamsee — Fri, 12 Nov 2021 01:02:21 GMT

Re: I am trying to connect to Azure Databricks SQL from my Spring Boot Application. is it possible to connect using the JDBC URL details. OR is it NOT supported yet. Please let me know.

Prabakar — Fri, 12 Nov 2021 07:14:13 GMT

Hi @Vamsee krishna kanth Arcot Databricks classloader does not support loading classes from the Spring Boot uber jar.

There is a workaround that involves

Using an init script, you can replace the default spring jar installed in databricks cluster with required version. Follow the steps mentioned in the KB: https://docs.microsoft.com/en-us/azure/databricks/kb/libraries/replace-default-jar-new-jar
Use the maven-shade-plugin to build the jar

Re: I am trying to connect to Azure Databricks SQL from my Spring Boot Application. is it possible to connect using the JDBC URL details. OR is it NOT supported yet. Please let me know.

Prabakar — Wed, 17 Nov 2021 16:19:17 GMT

Hi @Vamsee krishna kanth Arcot did the workaround help you resolve the issue?

Re: I am trying to connect to Azure Databricks SQL from my Spring Boot Application. is it possible to connect using the JDBC URL details. OR is it NOT supported yet. Please let me know.

Vamsee — Wed, 17 Nov 2021 17:24:46 GMT

Hi @Prabakar Ammeappin ,

I didnot understand what are u referring to .

anyways I could download the jar SparkJDBC42.jar and include it in my spring boot application in IntelliJ IDE.

also I am trying to connect using the below code.

DriverManagerDataSource dataSource = new DriverManagerDataSource();

dataSource.setDriverClassName("com.simba.spark.jdbc.Driver");

I am yet to test it, but my question is since the JAR is NOT available through maven, what is the alternative ?.

Do we need to manually install it on every server irrespective of whether it is dev/qa/prod.

Re: I am trying to connect to Azure Databricks SQL from my Spring Boot Application. is it possible to connect using the JDBC URL details. OR is it NOT supported yet. Please let me know.

User16871418122 — Wed, 24 Nov 2021 07:25:01 GMT

Hi @Vamsee krishna kanth Arcot Yes, currently you will have to download the JDBC from https://databricks.com/spark/jdbc-drivers-download and connect from other applications with JDBC URL just like you mentioned in your example.

There is an internal request (DB-I-4081 Publish databricks JDBC driver to maven central). This request shall be upvoted if you own a databricks ideas portal login. The upvotes would accelerate the priority of this request.