This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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
    Sheriff
    Posts: 51450
    87
    • 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: 3585
    16
    Android Java
    • 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 ...
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic