Comments (3)
I believe this is a known bug that may have been fixed in another version of the JDBC driver.
I think I found the same issue reported by someone else, and tracked down a fix. The fix might be in a recent version of the jdbc driver.
microsoft/mssql-jdbc#1831
The fix might be in :
[12.4.0] - A Stable Release
This fix appears to have been introduced as recently as June 2023.
I'm not that familiar with the Java ecosystem. When the README for this project says you support the 8.4.1 version of the driver, does that mean we should avoid all the more recent ones? I found the following jdbc in maven :
https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc/12.4.0.jre8
... I'm wondering if this jdbc is something that I can use, albeit at my own risk? Why does the README not mention the other versions of the jdbc driver? The one it does mention is many years old. Any information would be greatly appreciated.
from sql-spark-connector.
I might just close this now. I will probably try to find another path forward.
from sql-spark-connector.
Closing for now. Will investigate workarounds.
from sql-spark-connector.
Related Issues (20)
- .format("com.microsoft.sqlserver.jdbc.spark") does not work on Azure Databricks Spark 3.2+
- java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver HOT 1
- writing with mode "append" to an existing table only rolls back faulty rows w/o "NO_DUPLICATES"
- [Question] how to set MAXDOP
- Error while writing - com.microsoft.sqlserver.jdbc.SQLServerException: The connection Is closed. HOT 1
- Missing Maven distros HOT 6
- Need the ability to use a linked service in a notebook to do a connection to a database
- Don't run the AFTER insert trigger
- Possible Wheel (.whl) distribution? HOT 1
- GA versions HOT 2
- TIMESTAMP to datetime2 fails on Azure Synapse HOT 1
- Connection closed when try to use om.microsoft.sqlserver.jdbc.spark connector HOT 4
- Version 8.4.1 of Microsoft JDBC Driver For SQL Server
- [Request] Support Spark 3.5 HOT 1
- Does bulk upsert data import support?
- Support for Spark 3.4.x HOT 2
- Assessing the risk of duplicated entries for BEST_EFFORT reliabilityLevel HOT 1
- sql-spark-connector issue where the access token expires post 60 mins HOT 1
- Intermittent Authentication Failure using ActiveDirectoryPassword
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql-spark-connector.