05-25-2022 07:57 AM
import com.databricks.client.jdbc.DataSource;
import java.sql.*;
public class testDatabricks {
public static void main(String[] args) throws SQLException {
String dbUrl = "jdbc:databricks://<hostname>:443;HttpPath=<HttpPath>;";
// Copied the hostname and httppath from configuration of instance
DataSource d = new DataSource();
d.setURL(dbUrl);
d.setUserID("token");
d.setPassword("<access-token>");
// Copied access token from user settings
Connection conn = d.getConnection();
Statement s = conn.createStatement();
ResultSet r = s.executeQuery("show schemas");
while(r.next()) {
System.out.println(r.getString("databaseName"));
}
System.out.println("Success");
}
}
I am trying to execute this code to test connection to my Databricks instance. But I get
java.sql.SQLNonTransientConnectionException: [Databricks][JDBC](12330) Cannot establish a successful connection with given properties.
error. Am I missing anything in the setup?
Also, why is the driver guide (Installation and Configuration) missing in then docs folder of the driver?
05-26-2022 03:04 AM
This looks like due to maintenance on US . Are you still facing the issue @Sriramkumar Thamizharasan Is your workspace on eastus and eastus2 ?
05-26-2022 06:54 AM
My workspace is in us-west-2 region. I still face the issue. Although, interestingly, if I keep the code same and just change the JDBC URL to start with jdbc:spark:// instead of jdbc:databricks://, the connection is successful.
Also, could we get the Installation and Configuration Guide that comes with the driver?
05-26-2022 10:29 AM
Looked into the decompiled source and found that only "spark" is added as sub protocol in DataSource class but in Driver class "databricks" is added.
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group