Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade MS SQL driver #337

Open
chalkos opened this issue Nov 12, 2018 · 1 comment
Open

Upgrade MS SQL driver #337

chalkos opened this issue Nov 12, 2018 · 1 comment
Labels
enhancement Issue type ms sql Microsoft SQL Server database module
Milestone

Comments

@chalkos
Copy link
Contributor

chalkos commented Nov 12, 2018

The driver being used is sqljdbc4, version 4.0 which is not able to connect to MS SQL databases using windows integrated login (see #336).

According to this support & compatibility matrix, support for the version being used stopped on March 6, 2017.

Also according to the same matrix, the appropriate version to use is 6.2, since it is the most recent version that is compatible with all systems that 4.0 supported (e.g. version 6.4 drops support for SQL Server 2008), and is compatible with Java 7.
As a bonus, using version 6.2 will (theoretically) add support for SQL Server 2017.

Driver version 7.0 drops support for Java 7, which might be a problem in the future, but since version 6.2 will be supported until June 30, 2022, it is something to worry about later.

@chalkos chalkos added enhancement Issue type ms sql Microsoft SQL Server database module labels Nov 12, 2018
@chalkos chalkos self-assigned this Nov 12, 2018
@chalkos
Copy link
Contributor Author

chalkos commented Nov 12, 2018

maven info for the new driver: https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement Issue type ms sql Microsoft SQL Server database module
Projects
None yet
Development

No branches or pull requests

2 participants