wood burning stoves 2.0*
The moose likes JDBC and the fly likes Best JDBC driver for SQL server.. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Best JDBC driver for SQL server.." Watch "Best JDBC driver for SQL server.." New topic
Author

Best JDBC driver for SQL server..

Antonio Giovanni
Ranch Hand

Joined: Jun 27, 2005
Posts: 85
Hi all,..

well i did search for this in the JDBC forum,.. i guess the open-source jTDS was suggested.. Are there any other better JDBC drivers, which can be purchased?? I do not want to limit myself to just some free open-source JDBC drivers to access SQL server.. or still you people would say jTDS is the best.

Thanks a lot for your suggestions.
Melinda Savoy
Ranch Hand

Joined: Jun 21, 2005
Posts: 386

The one I found that works best was that from the microsoft.com site. Their JDBC driver seemed to work best for me.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Microsoft's own driver has issues, so I wouldn't use it in a production system. MS are in thbe process of releasing a new version, so maybe it will get better. jTDS is good enough as far as we've dicovered. DataDirect is the mojst commonly mentioned commercial driver - I haven't really used it so I can't say whether it is any better then jTDS.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Alin Sinpalean
Greenhorn

Joined: Jun 02, 2005
Posts: 6
First of all, a disclaimer: I am a jTDS developer.

Second, jTDS is not "just some free open-source JDBC driver". It's as fast as any of the commercial drivers and definitely more stable than the MS one. And I would be worrying more about stability than performance.

Third, the old MS driver is a 4 year old OEM-ed DataDirect driver with almost no bugs fixed and no features added. The new MS driver is a brand new OEM-ed JNetDirect driver, so it's much better than the old one (both in terms of speed and stability) but it still has a lot of issues (I found literally tens of bugs while getting it through the jTDS test suite). Also, I'm willing to bet that once the new driver gets out of beta it will be artificially limited to SQL Server 2005 (currently it works even with SQL Server 6.5, although that's not documented). And support for the new driver will probably be as good as for the old one since they didn't even bother to write it and instead just bought one.

There you have it. My biased $.02.

Alin,
The jTDS Project.
Antonio Giovanni
Ranch Hand

Joined: Jun 27, 2005
Posts: 85
Thanks guys for your suggestions
 
jQuery in Action, 2nd edition
 
subject: Best JDBC driver for SQL server..