Using JTDS driver

Question

Hi Everyone

I just want to know your opinion.

I have here a situation. I have a almost release ready (release in 2 month) application that runs queries on the microsoft Sql-Server database.We use the standard Microsoft jdbc driver implementation for sql-server. Works great,no problems.

Now there come a developer to me and says that i we should switch our default jdbc implementation to the the JTDS driver implementation.

I read in the web a little about the driver and its benchmarks and so on , and it really seems to perform a little better the the driver from Microsoft.

But taking in consideration the release soon and that the driver is opensource and all the other stuff that i currently dont think of it right now , would you invest your time to make the switch ?

Thanks

Answer 1

I've used the JTDS driver in production for around a year without any problems.

However, in your case, if you've got a system that been built and tested with the MS JDBC driver, then you really ought to stick to that.

In the meantime, conduct some tests and see if you can collect hard figures that show JTDS outperforming MS JDBC for your use cases. If the data back up these assertions, then come up with a plan to start using JTDS in your development and test cycles, finally rolling it out to your production release.

Answer 2

Close to release, no.

Do it later, yes.

JTDS has benefits over the MS one such as you can use a domain service account for your SQL connection and supports encrpyted SSL.