Databricks jdbc driver connectiion issue with apache solr

[Bhavishya]

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

[Kaniz_Fatma · Accepted solution]

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]

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

[Bhavishya]

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