Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes JDBC and Relational Databases and the fly likes JDBC Driver for MSSQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC Driver for MSSQL" Watch "JDBC Driver for MSSQL" New topic

JDBC Driver for MSSQL

Suresh Kanagalingam
Ranch Hand

Joined: Aug 17, 2001
Posts: 82

I am looking for a JDBC driver for MS SQL dB. When I checked different sites I get the feeling that MS SQL JDBC driver is not stable (memory leak, cursor not closing properly).

Can anyone suggest a JDBC driver (free) that is stable with MS SQL?

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

My experience is there are no non-commercial JDBC drivers out there for MSSQL which are really good enough for a production system. Of the commercial ones Data Direct's offering is pretty good. Of the open source ones jTDS is nearly there, and far better than MS's own offering.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
David Yutzy
tumbleweed and gunslinger
Ranch Hand

Joined: Jun 29, 2001
Posts: 192
We've had bitter experience with MS's JDBC Driver and it's aweful. On high traffic sites, it brings the application server to it's knees pretty quick.

We're using JTDS and haven't looked back.
Prashant Jain

Joined: Aug 19, 2004
Posts: 29
Microsoft driver is pretty bad. So much so that if you try and prepare two statements on the same connection object it will implicitly open another connection! JTDS driver isnt bad and its free but I have faced few issues with it while working on time stamp fields. Data direct is good and so J SQL Connect. See what fits your needs.

Prashant Jain.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: JDBC Driver for MSSQL