Is there a current opinion which MS SQL-Server JDBC driver I should use:
The official MS one: http://msdn.micros开发者_如何学Coft.com/en-us/sqlserver/aa937724
or JTDS: http://jtds.sourceforge.net/
And why?
The JTDS project look like is halted, the last release was 2 years ago, and it don't support many features that the official one has.
When a new release of SQL Server brings some new feature, like AlwaysON or Always Encrypted, Microsoft tries to release a JDBC driver with support for those features.
Check out the recently released JDBC 4.2 with support for JDK 8 and better support for XA transactions, it's almost on pair with the ADO.NET driver.
http://blogs.technet.com/b/dataplatforminsider/archive/2015/09/02/download-the-new-jdbc-4-2-for-sql-server-driver.aspx
精彩评论