从Microsoft jdbc驱动程序切换到JTDS驱动程序的优缺点是什么? [英] What are the advantages or disadvantages of switching to JTDS driver from Microsoft jdbc driver?

问题描述

我这里有个情况.我有一个几乎可以发布的应用程序(将在2个月内发布)，该应用程序可以在Microsoft Sql-Server数据库上运行查询.我们对sql-server使用标准的Microsoft jdbc驱动程序实现.效果很好，没问题.

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.

现在有一个开发人员来找我，说我应该将默认的jdbc实现切换到JTDS驱动程序实现.

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

我在网络上阅读了一些有关该驱动程序及其基准的信息，等等，实际上它的性能似乎要好于Microsoft的驱动程序.

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?

推荐答案

我们使用jTDS驱动程序已有大约一年的时间.截至今天，我可以告诉您以下信息:

We are using jTDS drivers for about an year. As of today, I can tell the following:

优点:

• 较小的JAR.
• ResultSets更快.提取是可配置的.
• 在磁盘上缓存大量结果(MS驱动程序要求您使用慢速双向游标或在内存上缓存结果，偶尔会产生OutOfMemoyErrors).
• 文档虽然很小，但足够了(MS驱动程序文档分布在数百个MSDN页面中).
• 更好的错误报告(总是一个不错的SQLException，而MS驱动程序有时会给出ClassCastException或其他RuntimeException).
• 开源.

缺点:

• 支持不佳，原因是:
  • 相对较小的用户群，提供了不好的社区支持.
  • 没有大公司的支持，因此，如果您需要快速的解决方案，那么您必须希望开发人员有空并愿意提供帮助(并且请记住，他们没有为回答论坛消息而付费).
  • Bad support, due to:
    • Relatively small user base, giving bad community support.
    • Not backed by a big company, so if you need some solution fast, you must hope the developers are available and willing to help (and remember they are not paid for answering forums messages).

    这篇关于从Microsoft jdbc驱动程序切换到JTDS驱动程序的优缺点是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！