Databricks jdbc driver connectiion issue with apache solr
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023 02:10 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-07-2024 09:01 AM
Hi Bhavishya, I am facing the same issue. Were you able to find a solution to this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-21-2024 12:37 AM
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
