cancel
Showing results for 
Search instead for 
Did you mean: 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results for 
Search instead for 
Did you mean: 

Databricks jdbc driver connectiion issue with apache solr

Bhavishya
New Contributor II

Hi,

databricks jdbc version - 2.6.34

I am facing the below issue with connecting databricks sql from apache solr 
Caused by: java.sql.SQLFeatureNotSupportedException: [Databricks][JDBC](10220) Driver does not support this optional feature.

at com.databricks.client.exceptions.ExceptionConverter.toSQLException(Unknown Source)at com.databricks.client.jdbc.common.SConnection.setAutoCommit(Unknown Source)
at com.databricks.client.jdbc.jdbc42.DSS42Connection.setAutoCommit(Unknown Source)
at org.apache.solr.handler.dataimport.JdbcDataSource$1.initializeConnection(JdbcDataSource.java:223)
at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:197)
... 57 more

1 ACCEPTED SOLUTION

Accepted Solutions

Kaniz_Fatma
Community Manager
Community Manager

Hi @Bhavishya, You’re encountering an issue connecting to Databricks SQL from Apache Solr. 

 

The error message indicates that the JDBC driver is not supporting an optional feature. 

 

Let’s explore some potential solutions:

 

Driver Compatibility:

  • Ensure that you are using a compatible version of the Databricks JDBC driver. The version you mentioned is 2.6.34.
  • Sometimes, specific features might not be supported in certain driver versions. Consider checking if there are any updates or patches available for the driver.

Permissions and Configuration:

  • Verify that your Databricks cluster has the necessary permissions for external connections.
  • Ensure that the Databricks cluster is running and accessible.
  • Check if the Databricks JDBC driver is correctly configured in your Solr setup.

Check the JDBC URL:

  • Double-check the JDBC URL you are using to connect to Databricks SQL. Make sure it is correctly formatted and points to the right Databricks cluster.
  • If you’re using any query options or additional parameters in the URL, ensure they are valid.

Troubleshoot with Databricks Documentation:

  • Refer to the official Databricks documentation for troubleshooting steps related to JDBC connections.
  • Look for specific guidance for connecting Databricks SQL with external tools like Solr.

Remember that your error message indicates that the driver does not support an optional feature. Investigating the compatibility, permissions, and configuration aspects should help narrow down the issue. If you need further assistance, consider contacting Databricks support or community forums for more ....

 

Please let me know if you need additional help or if you encounter any other issues! 😊

View solution in original post

3 REPLIES 3

Kaniz_Fatma
Community Manager
Community Manager

Hi @Bhavishya, You’re encountering an issue connecting to Databricks SQL from Apache Solr. 

 

The error message indicates that the JDBC driver is not supporting an optional feature. 

 

Let’s explore some potential solutions:

 

Driver Compatibility:

  • Ensure that you are using a compatible version of the Databricks JDBC driver. The version you mentioned is 2.6.34.
  • Sometimes, specific features might not be supported in certain driver versions. Consider checking if there are any updates or patches available for the driver.

Permissions and Configuration:

  • Verify that your Databricks cluster has the necessary permissions for external connections.
  • Ensure that the Databricks cluster is running and accessible.
  • Check if the Databricks JDBC driver is correctly configured in your Solr setup.

Check the JDBC URL:

  • Double-check the JDBC URL you are using to connect to Databricks SQL. Make sure it is correctly formatted and points to the right Databricks cluster.
  • If you’re using any query options or additional parameters in the URL, ensure they are valid.

Troubleshoot with Databricks Documentation:

  • Refer to the official Databricks documentation for troubleshooting steps related to JDBC connections.
  • Look for specific guidance for connecting Databricks SQL with external tools like Solr.

Remember that your error message indicates that the driver does not support an optional feature. Investigating the compatibility, permissions, and configuration aspects should help narrow down the issue. If you need further assistance, consider contacting Databricks support or community forums for more ....

 

Please let me know if you need additional help or if you encounter any other issues! 😊

Charlie-Tirrell
New Contributor II

Hi Bhavishya, I am facing the same issue. Were you able to find a solution to this?

Bhavishya
New Contributor II

Databricks team recommended to set IgnoreTransactions=1 and autocommit=false in the connection string but that didn't resolve the issue .
Ultimately I had to use solr update API for uploading documents

Connect with Databricks Users in Your Area

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