differences between ms sql microsoft's jdbc drivers and jTDS's driver

java sql-server jdbc jtds
opensas picture opensas · Dec 9, 2010 · Viewed 26.6k times · Source

What are the differences between each driver? I mean, besides one of them being open-source

What are the pros / cons of each one?

Which one would you recommend?

here's jTDS own opinion on the subject: http://jtds.sourceforge.net/

Answer

jzd picture jzd · Dec 9, 2010

They are distinct implementations. The jTDS driver is a type 4 and in my experience has better performance. I have been using the jTDS driver in a production environment without any issues for 5 years.

I would recommend going with jTDS.

Related questions

What is the jTDS JDBC Connect URL to MS SQL Server 2005 Express

I'm trying to connect to a MS SQL Server 2005 Express database that is running on the local host from a java program. I have tried the same connect URL (below) that I used on another system (same jave code) that …

Read More
Java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver On Android

Today I am doing Connectivity of SqlServer using JTDS driver. But when I run program I found Below error Java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver Caused by: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver in loader dalvik.…

Read More
SQL server "Lock request time out period exceeded" .. again

I'm having a problem trying to extend the lock timeout in a sql server SP. No matter what I try it keeps throwing "Lock request time out period exceeded". I'm using java + jtds 1.2.2, c3p0 0.9.1 and sql server 2008. The settings …

Read More