Skip to content
This repository has been archived by the owner on Oct 12, 2023. It is now read-only.

Incompatible With MSSQL Driver 8.2.2?? #76

Closed
devmanhinton opened this issue May 8, 2020 · 1 comment
Closed

Incompatible With MSSQL Driver 8.2.2?? #76

devmanhinton opened this issue May 8, 2020 · 1 comment

Comments

@devmanhinton
Copy link

Please close this if I am wrong. ReadMe notes this works with mssql driver 6.2+

Screen Shot 2020-05-08 at 11 30 31 AM

Ran with 8.2.2.jre8 and ran into

java.lang.NoSuchMethodError: com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeToServer(Lcom/microsoft/sqlserver/jdbc/ISQLServerBulkRecord;)V
	at com.microsoft.azure.sqldb.spark.connect.DataFrameFunctions.com$microsoft$azure$sqldb$spark$connect$DataFrameFunctions$$bulkCopy(DataFrameFunctions.scala:127)
	at com.microsoft.azure.sqldb.spark.connect.DataFrameFunctions$$anonfun$bulkCopyToSqlDB$1.apply(DataFrameFunctions.scala:72)

Downgraded to 7.4.1.jre8 and it works

@arvindshmicrosoft
Copy link
Contributor

Thank you @devmanhinton for your interest and efforts to document your issue. Given the 8.2 release JDBC release is relatively new, I am not aware of any testing that was done with that driver version. So I will close this issue with a promise to update the README to reflect this limitation.

Also, consider evaluating the
Apache Spark Connector for SQL Server and Azure SQL which is a newer connector. That connector improves the experience around bulk load, and adds other improvements like Python and R bindings etc. However at this time I am not sure about the supportability for MSSQL JDBC 8.2.2 in that connector, either.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants