I am trying to connect to databricks using java code. Can someone help me please? Here is the code so far I have got::

  
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.SQLException; 
import java.util.Properties;
  public class DatabricksSetup {
    public static void main(String[] args) throws SQLException {
      String url = "jdbc:databricks://XXXX.azuredatabricks.net:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/XXXXX;AuthMech=3;UID=token;PWD=XXXXXX";
       String username = "token";
       String password = "XXXX"; //Token generated from databricks profile page.
       Connection connection = DriverManager.getConnection(url, username, password);
       System.out.println("Database connected!");
       if(connection != null){
         System.out.println("Connection Established");
       else {
         System.out.println("Connection Failed");
  }

Below dependancy is already added :

"com.databricks:databricks-jdbc:2.6.25"

Error :

Exception in thread "main" java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 403, Error message: Unknown.

at com.databricks.client.hivecommon.api.HS2Client.handleTTransportException(Unknown Source)

at com.databricks.client.spark.jdbc.DowloadableFetchClient.handleTTransportException(Unknown Source)

at com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source)

at com.databricks.client.hivecommon.api.HS2Client.<init>(Unknown Source)

at com.databricks.client.spark.jdbc.DowloadableFetchClient.<init>(Unknown Source)

at com.databricks.client.spark.jdbc.DownloadableFetchClientFactory.createClient(Unknown Source)

at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.connectToServer(Unknown Source)

at com.databricks.client.spark.core.SparkJDBCConnection.connectToServer(Unknown Source)

at com.databricks.client.hivecommon.core.HiveJDBCCommonConnection.establishConnection(Unknown Source)

at com.databricks.client.spark.core.SparkJDBCConnection.establishConnection(Unknown Source)

at com.databricks.client.jdbc.core.LoginTimeoutConnection.connect(Unknown Source)

at com.databricks.client.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)

at com.databricks.client.jdbc.common.AbstractDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at digital.eComm.ui.tests.DatabricksSetup.main(DatabricksSetup.java:16)

Caused by: com.databricks.client.support.exceptions.ErrorException: [Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 403, Error message: Unknown.

... 16 more

If there isn’t a group near you, start one and help create a community that brings people together. Request a New Group Connecting to Databricks from Workato. JDBCDriver 500593 Communication Link failure in Administration & Architecture Monday Databricks to IDT Connection using Databricks Service Principal in Data Engineering 07-10-2024 DBEAVER Connection to Sql Warehouse in Databricks in Data Engineering 04-08-2024 How Can Companies Organize Their Data Through Data Governance? in Data Governance 12-19-2023 Thread leakage when connection cannot be established in Data Engineering 08-09-2023 © Databricks 2024. All rights reserved. Apache, Apache Spark, Spark and the Spark logo are trademarks of the Apache Software Foundation.