• Post Reply Bookmark Topic Watch Topic
  • New Topic

Which JDBC Driver for SQL Server2008?

 
AhFai Chan
Ranch Hand
Posts: 81
Android Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi... again.

I was reading up on JDBC drivers for SQL Server 2008, there seems to be quite a few:
  • Microsoft JDBC driver ( formerly NetDirect JSQLConnect ) - free
    Progress DataDirect - cost $$$
    JTDS - free
    INET Merlia - cost $$$
    JNetDirect JSQLConnect - free for 1 developer connection


  • Counter intuitively, Microsoft's JDBC seems to have its share of problems connecting to SQL Server2008. This is what I read:

    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

    Can anyone expert please share their experience and recommendations, obviously, the free ones are preferred.
     
    Campbell Ritchie
    Marshal
    Posts: 53140
    124
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Don't know. I would be surprised if Microsoft are still maintaining a 7‑year‑old version of SQLServer.

    Moving to our databases forum.
     
    K. Tsang
    Bartender
    Posts: 3610
    16
    Firefox Browser Java Mac OS X
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Go with the MS JDBC 4 jar file.

    Not too aware of the problems, at least I didn't

    The connection pooling thing is done on the application server.
     
    AhFai Chan
    Ranch Hand
    Posts: 81
    Android Eclipse IDE Java
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    K. Tsang wrote:Go with the MS JDBC 4 jar file.

    Not too aware of the problems, at least I didn't

    The connection pooling thing is done on the application server.


    Thanks ...
     
    What are you doing? You are supposed to be reading this tiny ad!
    the new thread boost feature brings a LOT of attention to your favorite threads
    https://coderanch.com/t/674455/Thread-Boost-feature
    • Post Reply Bookmark Topic Watch Topic
    • New Topic
    Boost this thread!