List of JDBC drivers for SQL Server 2008 (comparison)

Question

I am evaluating a range of JDBC drivers, in particular for use with SQL Server 2008 with Windows Authentication. I put together a list of the ones I found and listed them below.

My question is, are there other SQL Server 2008 compatible JDBC drivers that I should also explore in a review?

• Microsoft JDBC Driver

  URL : http://msdn.microsoft.com/en-us/sqlserver/aa937724

  Benefits : Official Microsoft JDBC driver for SQL Server 2008! Based on the JSQLConnect JNetDirect v3 driver that Microsoft acquired several years ago, they have been built on top of it since then. This was told to me by JNetDirect JSQLConnect support.

  Cons It seems you have a lot of connectivity / stability issues, don't believe me, just google about it :). There is no way to disable the preparation / aggregation of statements that I am looking for.

  JDBC Compliance : Claims must be compatible with JDBC 4.0, although many methods throw a UnimplementedException !!!!

  JDBC Type : 4

  Price : Free

• Progress DataDirect

  URL : http://www.datadirect.com/index.html

  Pros . Claims for the first-class class used by numerous applications such as Informatica, etc., and the company has been around for ages! Quick support - I talked to them briefly.

  Against :?

  JDBC Compliance : Claims Must Be JDBC 4.0 Compliant

  JDBC Type : 5

  Price : not free

• Jtds

  URL : http://jtds.sourceforge.net/

  Benefits : Much faster than the official Microsoft JDBC driver. Has a way to disable prepared statements.

  Against :?

  JDBC Compliance : JDBC 3.0 only. This is a transaction interrupt for me, because important methods like .validate () and .isClosed () are not supported, because these are JDBC 4.0 methods.

  JDBC Type : 4

  Price : Free - Open Source

• INET Merlia

  URL : http://www.inetsoftware.de/products/jdbc-driver/ms-sql/merlia

  Benefits : Much faster than the official Microsoft JDBC driver. Has a way to disable prepared statements.

  Against :?

  JDBC Compliance : Claims Must Be JDBC 3.0 / 4.0 Compliant

  JDBC Type : 4

  Price : not free

• JNetDirect JSQLConnect

  URL : http://www.jnetdirect.com/products/jsqlconnect.html

  Benefits : Much faster than the official Microsoft JDBC driver. Has a way to disable prepared statements

  Against :?

  JDBC Compliance : Claims Must Be JDBC 3.0 / 4.0 Compliant

  JDBC Type : 4

  Price : Free for one user with 1 database connection.

If you can keep your comments clean, I will gladly update this post with any others.