jTDS官方介绍（OpenCmsv6.2版MSSqlserver数据库支持所用JDBC驱

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了jTDS官方介绍（OpenCmsv6.2版MSSqlserver数据库支持所用JDBC驱，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3810字，纯文字阅读大概需要6分钟。

内容图文

OpenCms6.2支持MS Sqlserver2000数据库，但其需要jTDS驱动，下面是jTDS的官方介绍和下载地址。 Overview jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12, 15).

OpenCms6.2支持MS Sqlserver2000数据库，但其需要jTDS驱动，下面是jTDS的官方介绍和下载地址。
Overview

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12, 15). jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for SQL Server and Sybase. jTDS is 100% JDBC 3.0 compatible, supporting forward-only and scrollable/updateable ResultSets, concurrent (completely independent) Statements and implementing all the DatabaseMetaData and ResultSetMetaData methods. Check out the feature matrix for more details.

Quite a few of the commercial JDBC drivers out there are based on jTDS (or FreeTDS), even if they no longer acknowledge this. jTDS has been tested with virtually all JDBC-based database management tools and is the driver of choice for most of these (recommended for DbVisualizer and SQuirreL SQL, distributed with Aqua Data Studio and DataDino). jTDS is also becoming a common choice for enterprise-level applications: it passes both the J2EE 1.3 certification and Hibernate test suites, and is recommended for JBoss, Hibernate, Atlassian JIRA and Confluence and Compiere.

Getting Started

Being a type 4 driver, jTDS does not need any special installation. Just drop the jar file into your application's classpath and you're done. All you need to know is the name of the Driver and DataSource implementations and the URL format and you're all set. You can get these and a lot more information from the Frequently Asked Questions page. For features needing native libraries such as XA support or Single-Sign-On consult the specific README files.

Why use jTDS?

jTDS is free software. jTDS is released under the terms of the GNU LGPL, giving you not only the posibility to debug and tweak it to your own liking but also to use it in and distribute it with your free or commercial applications.

The other "free" choices, the JDBC-ODBC bridge and Microsoft's own JDBC driver are not actually free. If you encounter an issue with any of them you won't be able to fix it yourself and response times from both Microsoft and Sun are anything but short. Also, both of them lack functionality (the Microsoft driver implements JDBC 2.0, while the bridge is just a JDBC 1.0 implementation) and have serious stability problems: the bridge crashes the JVM if the ODBC driver has any problem and Microsoft just has no intention of really supporting Java/JDBC.

jTDS is also the most performant JDBC driver for both SQL Server and Sybase. We have an older benchmark result but we strongly encourage you to download any benchmark published by commercial JDBC driver vendors and see for yourself. Here are a couple of benchmarks you could use: JNetDirect's JDBC Performance Benchmark and i-net Software's BenchTest 2.1 for MS SQL Server.

Anyway, just give it a spin. Get the latest one from here and see whether you like it or not.

Support

Following a number of requests we have decided to offer commercial technical support for interested parties. For the moment you can get official technical support from individual developers of jTDS; contact any of us and we'll be happy to provide you with our tech support terms and conditions. Of course, we will keep offering support on our SourceForge forums just as we did until now; we are only trying to encourage adoption of jTDS, not make a fortune out of it.

引用出处：http://jtds.sourceforge.net/

jTDS驱动下载地址：http://sourceforge.net/projects/jtds

内容总结

以上是互联网集市为您收集整理的jTDS官方介绍（OpenCmsv6.2版MSSqlserver数据库支持所用JDBC驱全部内容，希望文章能够帮你解决jTDS官方介绍（OpenCmsv6.2版MSSqlserver数据库支持所用JDBC驱所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---