JDBC java drivers sql server 2005 [closed]

Question

We are upgrading our servers to SQL Server 2005 from SQL Server 2000. We currently use the jtds drivers.

I'm interested to know what peoples opinions are of the different jdbc drivers available (in particular the latest Microsoft driver), how they perform with SQL Server 2005 and any other lessons from your collective experience.

Answer 1

I have used the MS provided driver, the jtds driver, as well as the driver from jnetdirect.

Unfortunately none of them is perfect, and all have their own bugs (including of course Microsofts own). The MS provided drivers of course have support for the newest features before the other vendors, but I must say that I have rarely seen significant performance differences between drivers.

My advice would be to make sure that your application reads the driver name and connection URL from a properties file somewhere so that you can easily switch between drivers if you run into problems with whichever one you choose. You'll be glad you did later.