well i did search for this in the JDBC forum,.. i guess the open-source jTDS was suggested.. Are there any other better JDBC drivers, which can be purchased?? I do not want to limit myself to just some free open-source JDBC drivers to access SQL server.. or still you people would say jTDS is the best.
Microsoft's own driver has issues, so I wouldn't use it in a production system. MS are in thbe process of releasing a new version, so maybe it will get better. jTDS is good enough as far as we've dicovered. DataDirect is the mojst commonly mentioned commercial driver - I haven't really used it so I can't say whether it is any better then jTDS.
First of all, a disclaimer: I am a jTDS developer.
Second, jTDS is not "just some free open-source JDBC driver". It's as fast as any of the commercial drivers and definitely more stable than the MS one. And I would be worrying more about stability than performance.
Third, the old MS driver is a 4 year old OEM-ed DataDirect driver with almost no bugs fixed and no features added. The new MS driver is a brand new OEM-ed JNetDirect driver, so it's much better than the old one (both in terms of speed and stability) but it still has a lot of issues (I found literally tens of bugs while getting it through the jTDS test suite). Also, I'm willing to bet that once the new driver gets out of beta it will be artificially limited to SQL Server 2005 (currently it works even with SQL Server 6.5, although that's not documented). And support for the new driver will probably be as good as for the old one since they didn't even bother to write it and instead just bought one.