This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Best JDBC driver for SQL server.." Watch "Best JDBC driver for SQL server.." New topic

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: 387

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

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

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.

The jTDS Project.
Antonio Giovanni
Ranch Hand

Joined: Jun 27, 2005
Posts: 85
Thanks guys for your suggestions
I agree. Here's the link:
subject: Best JDBC driver for SQL server..
It's not a secret anymore!