针对SQL Server的Java [英] Java against SQL Server

问题描述

任何人都有使用Java对抗SQL Server的任何提示吗？我们的IT

导演正在考虑让我们成为一家Java商店，但我真的希望

继续使用SQL Server作为我们的RDBMS。我们有Oracle财务，但我们的内部开发（目前是VB6客户端服务器，很快就会被基于Sonic和/ br /的面向服务架构所取代）b $ b >
包括SalesForce，两者都是Java）已经反对SQL

Server。他说五年前在他的旧公司Java / SQL Server上有糟糕的表现。我依旧记得，从那以后，微软用他们自己的SQL Server JDBC驱动程序来获得
...任何人都有经验

这个？任何表演提示都将非常受欢迎。


TIA

Anyone have any tips for using Java against SQL Server? Our IT
director is thinking of making us a Java shop, but I really would like
to stay with SQL Server as our RDBMS. We have Oracle Financials but
our in-house development (currently VB6 client-server, soon to be
replaced by a service-oriented architecture based around Sonic and
including SalesForce, both of which are Java) has been against SQL
Server. He says five years ago at his old company Java/SQL Server had
lousy performance. I vaguely remember that since then Microsoft came
out with their own JDBC driver for SQL Server... Anyone have experience
with this? Any performance tips will be hugely appreciated.

TIA

推荐答案

Ellen K（ek *******@yahoo.com）写道：

Ellen K (ek*******@yahoo.com) writes:

任何人都有使用Java对抗SQL Server的任何提示？我们的IT主管正在考虑让我们成为一家Java商店，但我真的希望继续使用SQL Server作为我们的RDBMS。我们有Oracle财务，但我们的内部开发（目前VB6客户端服务器，很快将被基于Sonic的服务导向架构取代，包括SalesForce，两者都是Java）一直反对SQL
Server。他说五年前在他的旧公司Java / SQL Server上有糟糕的表现。我依旧记得，从那以后，微软带着他们自己的SQL Server JDBC驱动程序出来了......任何人都有这方面的经验吗？任何性能提示都将非常受欢迎。

Anyone have any tips for using Java against SQL Server? Our IT
director is thinking of making us a Java shop, but I really would like
to stay with SQL Server as our RDBMS. We have Oracle Financials but
our in-house development (currently VB6 client-server, soon to be
replaced by a service-oriented architecture based around Sonic and
including SalesForce, both of which are Java) has been against SQL
Server. He says five years ago at his old company Java/SQL Server had
lousy performance. I vaguely remember that since then Microsoft came
out with their own JDBC driver for SQL Server... Anyone have experience
with this? Any performance tips will be hugely appreciated.

MS驱动程序的最佳选择是价格标签。我相信驱动程序

是Datadirect Technologies的JDBC驱动程序的改编版本，

和Datadirect从那时起发布了更高版本。


我不太了解Java，但我在
。 sommarskog.se/mssqlperl/unix.htmltarget =_ blank> http://www.sommarskog.se/mssqlperl/unix.html 。


-

Erland Sommarskog，SQL Server MVP， es****@sommarskog.se


SQL Server SP3联机丛书
http://www.microsoft.com/sql/techinf...2000/books.asp

The best thing with the MS driver is the price tag. I believe the driver
is an adapted version of the JDBC driver from Datadirect Technologies,
and Datadirect has since then released a later version.

I don''t know much about Java, but I have a list of various offerings on
the market on http://www.sommarskog.se/mssqlperl/unix.html.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

非常感谢，埃兰。我去了你的页面和DataDirect，

将测试DataDirect和Microsoft的一个。

Thanks very much, Erland. I went to both your page and DataDirect,
will test the DataDirect one as well as the Microsoft one.

Erland Sommarskog写道：

Erland Sommarskog wrote:

MS驱动程序最好的是价格标签。我相信
驱动程序是Datadirect
Technologies的JDBC驱动程序的改编版本，而Datadirect从那时起发布了更高版本。

The best thing with the MS driver is the price tag. I believe the driver is an adapted version of the JDBC driver from Datadirect Technologies, and Datadirect has since then released a later version.

您也可以试用jTDS（ http://jtds.sourceforge.net ）;它是一个

开源（LGPL）JDBC 3.0实现，在我的测试中它比其他SQL Server驱动程序快b / b
。它也比MS驱动程序更加稳定

并得到更好的支持;你可以在DataDirect网站上找到一个问题列表

与MS驱动程序，这确实是一个非常古老的DataDirect驱动程序 - 他们在当前它们之间进行比较

驱动程序和MS一，与5年前的状态相同

发布时。


Alin，

jTDS项目。

You could also try out jTDS ( http://jtds.sourceforge.net ); it''s an
open source (LGPL) JDBC 3.0 implementation and in my testing it''s
faster than the other SQL Server drivers. It''s also much more stable
and better supported than the MS driver; you can find a list of issues
with the MS driver, which is indeed a very old DataDirect driver, on
the DataDirect site -- they have a comparison between their current
driver and the MS one, which is in the same state as it was 5 years ago
when it was released.

Alin,
The jTDS Project.

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