开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜