0

What is the fastest JDBC driver for Microsoft SQL Server?
Especially for SELECT operations with simple WHERE clauses, but also for INSERT and UPDATE operations.

It must also be reliable, free to use, and ideally open source.
It is for use within Apache Tomcat, if that matters. Memory usage is not a problem.

Both personal experiences and benchmarks welcome.

1

jTDS is an open source JDBC implementation for Microsoft SQL Server.

This benchmarks shows jTDS as faster for many tests, and in particular more than twice as fast as competitors for the "ResultSetReadAllRows" test:

jtds benchmark

The benchmark has been made by jTDS, so I am not sure how reliable it is, though. Other benchmarks would be welcome.

Drawbacks: jTDS is hosted on SourceForge and the last release was in 2013, with the last commit in November 2014.

| improve this answer | |
  • I have used jTDS in several projects and it was faster than the Microsoft implementation at the time (2014) and less buggy. However, Microsoft's JDBC driver is now open source on GitHub and it may be worth checking out as it is actively developed and supported with additional features like Windows Integrated Authentication and Distributed Transactions – ARau Feb 4 '17 at 14:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.