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

[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