7

I'm now trying to decide which driver to use to create a DataSource from my JavaEE application to MS SqlServer.

A couple of years ago I had good experience with JTDS, and SO answers suggest that JTDS was a preference back then.

But now I can see that its latest version 1.2.5 is two years old (2009-12-30).

Is it a good enough reason to choose MS proprietary driver, or is JTDS so good that it doesn't require any development anymore? :)

Community
  • 1
  • 1
Oleg Mikheev
  • 17,186
  • 14
  • 73
  • 95

1 Answers1

5

Microsoft JDBC driver is JDBC 4.0 compliant while jTDS is JDBC 3.0.

Here are some new features and improvements introduced in version 4.0 of JDBC.

Wojciech Owczarczyk
  • 5,595
  • 2
  • 33
  • 55
  • I'm not sure that I need JDBC 4.0 features because I'm doing the same old stuff that I was doing when 4.0 was not available, but [looking further](http://stackoverflow.com/a/8413767/513342) I found that proprietary driver might be even faster. Will accept your answer if no one proves the contrary. – Oleg Mikheev Dec 27 '11 at 09:23
  • I have never used MS driver either :). jTDS had never let me down and I heard it outperforms MS driver. – Wojciech Owczarczyk Dec 27 '11 at 09:37
  • JTDS has better features (eg Windows Auth from Windows etc). Older MS JDBC didn't support SSL either – gbn Dec 27 '11 at 09:39
  • JTDS is more convenient to use because it is available from Maven repo. So I'm hoping someone will persuade me that being old doesn't mean being outdated. – Oleg Mikheev Dec 27 '11 at 09:52
  • Eeek, I didn't know this. I'll have to review [jOOQ](http://www.jooq.org) for some `Blob.free()` and `Clob.free()` usage, and similar things! – Lukas Eder Feb 18 '14 at 16:57
  • 2
    *"JTDS is more convenient to use because it is available from Maven repo."* - As of November 2016, Microsoft's JDBC Driver for SQL Server is [open source](https://blogs.msdn.microsoft.com/jdbcteam/2016/11/17/open-source-jdbc-maven/) and [available from Maven](http://search.maven.org/#search%7Cgav%7C1%7Cg%3A%22com.microsoft.sqlserver%22%20AND%20a%3A%22mssql-jdbc%22). – Gord Thompson Feb 06 '17 at 18:50
  • Microsoft's JDBC Driver for SQL Server is in maven and it's actively being maintained. jTDS seems dead since Jun 08, 2013 – Jason Feb 20 '17 at 21:39