CODEWITHSUNDEEP
javasql-serverjdbcjtds
Oleg Mikheev
Oleg Mikheev

Reputation: 17444

is JTDS driver outdated?

I'm now trying to decide which driver to use to create a DataSource from my JavaEE application to MS SqlServer.

A couple of years ago I had good experience with JTDS, and SO answers suggest that JTDS was a preference back then.

But now I can see that its latest version 1.2.5 is two years old (2009-12-30).

Is it a good enough reason to choose MS proprietary driver, or is JTDS so good that it doesn't require any development anymore? :)

Upvotes: 9

Views: 4695

Answers (2)

David Mescher
David Mescher

Reputation: 11

Even with jTDS not being actively maintained, there are still reasons one might prefer the JTDS driver over the Microsoft driver.

The main one that I've experienced is the jTDS driver permits Windows and SQL Server authentication for the user, but the Microsoft driver requires the addition of a DLL file to the system path for that particular functionality. Without that DLL file, only SQL Server authentication is permitted with the Microsoft driver.

"To use integrated authentication, copy the mssql-jdbc_auth--.dll file to a directory on the Windows system path on the computer where the JDBC driver is installed." (https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16)

I haven't seen documentation on what you're supposed to do if you're not on a Windows system.

Upvotes: 0

Wojciech Owczarczyk
Wojciech Owczarczyk

Reputation: 5735

Microsoft JDBC driver is JDBC 4.0 compliant while jTDS is JDBC 3.0.

Here are some new features and improvements introduced in version 4.0 of JDBC.

Upvotes: 7

Related Questions