Can Microsoft JDBC Driver 4.0 connect to SQL Server 2019 and perform DML without issue?

All we need is an easy explanation of the problem, so here it is.

The SQL version compatibility BOL article advises that the minimum compatible JDBC driver version for SQL Server 2019 is 7.4.

Can an older JDBC driver still connect to SQL Server 2019? Or can only the driver versions listed as compatible connect to the specified SQL Server versions?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

Microsoft and my testing have confirmed that JDBC drivers not marked as compatible in the SQL version compatibility matrix might connect to a non compatible version of SQL Server and continue to work without issue.
 

However, there is no guarantee that all functionality detailed in the Driver feature support matrix for Microsoft SQL Server is supported. They also only test the driver versions marked as compatible against the stated version of SQL Server.

JDBC version 4.0 was not specifically tested.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply