Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Driver for MSSQL

 
Suresh Kanagalingam
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

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?

Thanks
Suresh
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
David Yutzy
tumbleweed and gunslinger
Ranch Hand
Posts: 192
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic