topic Re: Databricks jdbc driver connectiion issue with apache solr in Get Started Discussions

Databricks jdbc driver connectiion issue with apache solr

Bhavishya — Fri, 01 Dec 2023 10:10:07 GMT

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

Re: Databricks jdbc driver connectiion issue with apache solr

Charlie-Tirrell — Thu, 07 Mar 2024 17:01:39 GMT

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

Re: Databricks jdbc driver connectiion issue with apache solr

Bhavishya — Thu, 21 Mar 2024 07:37:08 GMT

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