What is the difference between :443/default and Database=default in JDBC connection string

charlie_cai — Thu, 27 Jul 2023 07:14:20 GMT

When I use following java code to get namespace from AWD Databricks:

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.Properties; public class DatabricksJDBCExample { public static void main(String[] args) { String jdbcUrl = "jdbc:spark://your-databricks-workspace-url:443/default;transportMode=http;ssl=true;httpPath=sql/protocolv1/o/your-org-id/your-workspace-id"; String accessToken = "token"; try { // Load the JDBC driver class Class.forName("com.databricks.driver.Driver"); Properties connectionProperties = new Properties(); // Set the necessary properties for the connection connectionProperties.setProperty("user", "token"); connectionProperties.setProperty("PWD", accessToken); // Create a connection using the JDBC URL and access token Connection conn = DriverManager.getConnection(jdbcUrl, connectionProperties); // Create a statement Statement stmt = conn.createStatement(); // Get the list of namespaces (databases) String showNamespacesQuery = "SHOW NAMESPACES"; ResultSet namespacesResult = stmt.executeQuery(showNamespacesQuery); System.out.println("Namespaces (Databases):"); while (namespacesResult.next()) { String namespace = namespacesResult.getString(1); System.out.println(namespace); } namespacesResult.close(); stmt.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } } }

I can get 'default' as result.

After I changed the connection string to database=default

String jdbcUrl = "jdbc:spark://your-databricks-workspace-url:443;transportMode=http;ssl=true;httpPath=sql/protocolv1/o/your-org-id/your-workspace-id;database=default";

It will throw error:

[SparkJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Configuration database is not available.:48:47

Re: What is the difference between :443/default and Database=default in JDBC connection string

Tharun-Kumar — Wed, 02 Aug 2023 07:44:11 GMT

@charlie_cai

database is not a valid configuration parameter available in the jdbc string. You can use ConnCatalog and ConnSchema to provide this information.

This is also documented here - https://docs.databricks.com/en/integrations/jdbc-odbc-bi.html#:~:text=To%20specify%20the%20default%20catalog%20and%20schema%2C%20add%20ConnCatalog%3D%3Ccatalog%2Dname%3E%3BConnSchema%3D%3Cschema%2Dname%3E%20to%20the%20JDBC%20connection%20URL.

topic What is the difference between :443/default and Database=default in JDBC connection string in Warehousing & Analytics

What is the difference between :443/default and Database=default in JDBC connection string

Re: What is the difference between :443/default and Database=default in JDBC connection string