- Free download page for Project jTDS - SQL Server and Sybase JDBC driver's jtds-1.2.7-src.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.
- Download Microsoft JDBC Driver for SQL Server.; 2 minutes to read Contributors. All; In this article Using the JDBC Driver with Maven Central.
- 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.
The interactive file manager requires Javascript. Please enable it or use sftp or scp.
You may still browse the files here.
You may still browse the files here.
Get project updates, sponsored content from our select partners, and more.
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 |
Feb 27, 2018 Download the Microsoft JDBC Driver 6.0 for SQL Server, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Editions.
Active9 months ago
What are the differences between each driver? I mean, besides one of them being open-source
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 Wagner11.6k44 gold badges4646 silver badges6363 bronze badges
opensasopensas28.1k6363 gold badges203203 silver badges309309 bronze badges
5 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.
jzdjzdJtds Jar Download
21.8k77 gold badges4949 silver badges7575 bronze badges
While 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.
VadzimVadzim16.6k44 gold badges8989 silver badges125125 bronze badges
Jtds Java
One 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.
felvhagefelvhage
Download Jtds Jdbc Driver
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.
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 Ryan15.3k2525 gold badges109109 silver badges140140 bronze badges
jTDSperformance 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.
AnilAnil