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]

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

There is a workaround that involves

1. 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
2. Use the maven-shade-plugin to build the jar

[Prabakar]

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

[Vamsee]

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.

[User16871418122 · Accepted solution]

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.