What are the differences between each driver? I mean, besides one of them being open-source
Download the SQL Server JDBC Driver 2.0, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5 and 6. Apr 03, 2009 Download the SQL Server JDBC Driver 2.0, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5 and 6. Download Microsoft JDBC Driver for SQL Server.; 2 minutes to read Contributors. All; In this article Using the JDBC Driver with Maven Central. Differences between ms sql microsoft's jdbc drivers. The jTDS driver is a type 4 and in my experience. The Microsoft SQL Server JDBC driver is a type 4. Free download page for Project jTDS - SQL Server and Sybase JDBC driver's jtds-1.3.1-dist.zip.Open source JDBC 3.0 type 4 driver for Microsoft SQL Server (6.5 up to 2012) and Sybase ASE. JTDS is a complete implementation of the JDBC 3.0 spec and the fastest JDBC driver for MS SQL Server.
What are the pros / cons of each one?
Which one would you recommend?
here's jTDS own opinion on the subject: http://jtds.sourceforge.net/
Adam Wagner5 Answers
They are distinct implementations. The jTDS driver is a type 4 and in my experience has better performance. I have been using the jTDS driver in a production environment without any issues for 5 years.
I would recommend going with jTDS.
jzdjzdWhile for many years jTDS was much superior than buggy mssql's own driver, the things are changing to the opposite recently.
Here is qoute from https://confluence.atlassian.com/bitbucketserver/transitioning-from-jtds-to-microsoft-s-jdbc-driver-776640388.html:
Why change drivers?
Recent releases of Hibernate, which Bitbucket Server uses to simplify its persistence layer, have introduced a requirement that the JDBC drivers and connection pools used be JDBC4-compliant. JDBC4 was introduced with Java 6.
The jTDS driver used by releases prior to Bitbucket Server 2.1 is a JDBC3 driver, compatible with Java 1.3, and therefore cannot be used with newer versions of Hibernate. While jTDS 1.3.0 and 1.3.1 claim to implement JDBC4, and JDBC4.1, they actually don't. The new methods have been 'implemented', but their implementations are all throw new AbstractMethodError(), which means they can't actually be used. (See an example here, on GitHub.)
Since jTDS 1.3.1 does not provide a functioning JDBC4 implementation, the decision was made to replace jTDS with Microsoft's own SQL Server driver. Microsoft's driver is actively maintained, where jTDS hasn't been updated since 2014 (and prior to the small round of updates done in 2014 it hadn't been updated for multiple years). Microsoft offers a full JDBC4.2 (Java 8) driver and supports all the features of SQL Server, including SQL Server 2016.
VadzimVadzimOne relevant difference is, that the JDBC 4.0 Implementation of the JTDS-Driver (v1.3.1) requires at least Java 7, whereas the JDBC 4.0 Implementation of the Microsoft driver is available in Java 6.
This is important if you want to use Hibernate 4.3 (relying on JDBC 4.0 API) and support Java 6. In that case JTDS is not an option.
The key reason FOR using jTDS is that it uses the lesser GPL license where Microsoft's driver uses their own license which has much more restrictions to it. One restriction of note is that you may not
- work around any technical limitations in the software
There are more restrictions within the license such as:
- transfer the software or this agreement to any third party
- use the software for commercial software hosting services
Which could be interpreted that you may not use it in production code, however earlier points in the license seem to allow it.
Having said all of this, I don't know of the licenses within SQL Server itself which may or may not restrict third-party drivers such as jTDS connecting to it.
Jtds Server Type
Another point is that jTDS is available via maven, the Microsoft driver is not.
For my choice, use jTDS, it is more permissive and least likely to get you into trouble, and; it's a better driver.
Brett RyanBrett RyanjTDSperformance is good, but looks like the fail-over property is not supported by jTDS, if the SQL Server switches to secondary, needed to restart the application/server for picking the new ip and reseting the connection.
Download Jtds Jdbc Driver
Not the answer you're looking for? Browse other questions tagged javasql-serverjdbcjtds or ask your own question.
Lotus Notes Sql Driver Download
The interactive file manager requires Javascript. Please enable it or use sftp or scp.
You may still browse the files here.
Odbc Sql Driver
| Name | Modified | Size | InfoDownloads / Week |
|---|---|---|---|
| Parent folder | |||
| 1.3.1 | 2013-06-08 | ||
| 1.2.8 | 2013-06-08 | ||
| 1.3.0 | 2012-10-27 | ||
| 1.2.7 | 2012-10-27 | ||
| 1.2.6 | 2012-09-07 | ||
| 1.2.5 | 2010-01-11 | ||
| 1.2.4 | 2009-09-29 | ||
| 1.2.3 | 2009-09-16 | ||
| 1.2.2 | 2007-08-22 | ||
| 1.2.1 | 2007-07-12 | ||
| 1.2 | 2005-11-08 | ||
| 1.1 | 2005-06-16 | ||
| 1.0.3 | 2005-04-15 | ||
| 1.0.2 | 2005-02-15 | ||
| 1.0.1 | 2005-02-09 | ||
| 1.0 | 2005-01-25 | ||
| 0.9.1 | 2004-12-08 | ||
| 0.9 | 2004-09-28 | ||
| 0.9-rc2 | 2004-08-28 | ||
| 0.9-rc1 | 2004-08-09 | ||
| 0.8.1 | 2004-07-08 | ||
| 0.8 | 2004-06-22 | ||
| 0.8-rc1 | 2004-03-30 | ||
| 0.7.1 | 2004-03-03 | ||
| 0.7 | 2004-02-26 | ||
| 0.6 | 2004-01-26 | ||
| 0.6-rc1 | 2003-12-22 | ||
| 0.5.2 | 2003-11-28 | ||
| 0.5.1 | 2003-01-31 | ||
| 0.5 | 2002-11-11 | ||
| 0.4 | 2002-10-14 | ||
| 0.3.2 | 2002-09-19 | ||
| 0.3.1 | 2002-09-06 | ||
| 0.3 | 2002-08-19 | ||
| 0.2 | 2002-07-16 | ||
| 0.1.1 | 2001-08-13 | ||
| 0.1 | 2001-08-10 | ||
| Totals: 37 Items | 2,036 | ||