List of JDBC drivers for SQL Server 2008 (comparison) [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

I am in the process of evaluating a whole whack of JDBC drivers, specifically to use with SQL Server 2008 with Windows authentication. I gathered a list of ones that I found and have listed them below.

My question is, are there any other JDBC drivers that are compatible with SQL Server 2008 that I should also look into reviewing?

1. Microsoft JDBC driver

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

   Pros: Official Microsoft JDBC driver for SQL Server 2008! Based on the JNetDirect JSQLConnect driver v3 as it was purchased by Microsoft a few years ago and they have been building on top of it since. I was told this by JNetDirect JSQLConnect's support.

   Cons: Seems to have a lot of connectivity/stability issues, don't believe me, just Google about it :). Doesn't have a way of disabling statement preparation/pooling which is something I am looking for.

   JDBC compliance: Claims to be be JDBC 4.0 compliant although many methods throw UnimplementedException!!!!

   JDBC Type: 4

   Price: Free

2. Progress DataDirect

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

   Pros: Claims to be top class, used by numerous applications like Informatica, etc and the company is been around for ages! Have quick support - I have dealt with them briefly.

   Cons: ?

   JDBC compliance: Claims to be be JDBC 4.0 compliant

   JDBC Type: 5

   Price: Not free

3. JTDS

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

   Pros: Much faster than the official Microsoft JDBC driver. Has a way of disabling prepared statements.

   Cons: ?

   JDBC compliance: JDBC 3.0 compliant only. This is a deal breaker for me because important me开发者_JS百科thods like .validate() and .isClosed() aren't supported because these are JDBC 4.0 methods.

   JDBC Type: 4

   Price: Free - Open Source

4. INET Merlia

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

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

   Cons: ?

   JDBC compliance: Claims to be be JDBC 3.0/4.0 compliant

   JDBC Type: 4

   Price: Not free

5. JNetDirect JSQLConnect

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

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

   Cons: ?

   JDBC compliance: Claims to be be JDBC 3.0/4.0 compliant

   JDBC Type: 4

   Price: Free for a single user with only 1 database connection.

If you can keep your comments clean, I'll happily update this post with any others.