SQL Server JBDC驱动程序比较 [英] SQL Server JBDC Driver comparison

问题描述

当前，我们使用 jtds 连接到我们的SQL Server数据库.由于性能和可靠性的原因，我一直认为我们使用它是理所当然的，但是，它的使用早于我的工作.

Currently we use jtds for connecting to our SQL Server databases. I've always taken it for granted that we use it due to performance and reliability reasons, however, it's usage pre-dates my employment.

所有这些，我们现在正在考虑迁移到SQL Server 2008的想法，而jtds对SQL Server 2008的支持有限.初步测试似乎表明，jtds的性能优于Microsoft在2005年提供的驱动程序.

All of that being said, we are now playing with the idea of moving to SQL Server 2008, which jtds has limited support for. Initial tests seem to indicate that jtds has better performance than the Microsoft supplied driver on 2005.

所以我的问题是，是否有人有任何经验证据或任何其他好的信息，否则表明哪种jdbc驱动程序最适合与SQL Server 2005和/或2008一起使用?

So my question is does anyone have any empirical evidence or any other good information otherwise indicating which jdbc driver is best suited for use with SQL Server 2005 and\or 2008?

jtds更好吗? Microsoft提供的驱动程序?还有吗?

Is jtds better? The driver supplied by Microsoft? Something else?

我已经考虑过进行概要分析，但是对于这是否真的可以证明任何事情感到怀疑.

I've thought about profiling, but have doubts about whether this will really prove anything.

推荐答案

我们有使用MSFT驱动程序和JTDS的经验，我们选择了不加疑问"的JTDS驱动程序. 减少了UNK问题，提高了性能和可靠性. 没有可用的图表，但是我们的产品是安装超过3k的加油站的POS.

We had experience using the MSFT driver vs JTDS and we chose WITH NO DOUBTS the JTDS driver. Got less UNK problems, better performance and reliability. Not have any chart to demostrate, but our product is a POS for gas stations with more than 3k installations.

我们是sql 2005，2008年没有尝试过.

We are sql 2005, didn't tried in 2008.

这篇关于SQL Server JBDC驱动程序比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！