Home | FAQ | Documentation | Links | License | Project Info | Download | News | Bugs | Forums
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.
Form：http://jtds.sourceforge.net/
分享到：
相关推荐
JTDS（Java JDBC Driver for Sybase and Microsoft SQL Server）是一个开源的JDBC驱动，它允许Java开发者利用JDBC API来访问和操作Sybase数据库，同时也支持Microsoft SQL Server。 JDBC（Java Database ...
"jdbc:jtds:sqlserver://" + props.getProperty("servername") + (props.getProperty("portNumber") != null ? ":" + props.getProperty("portNumber") : "") + (props.getProperty("instanceName") != null ? ...
jTDS - SQL Server and Sybase JDBC driver 1.2.2 正式版 <br>一个Microsoft SQL Server数据库的Jdbc driver。开源的非常好用。 下载地址：http://jtds.sourceforge.net/<br><br><br>
首先，标题"Kettle连接SQLServer连不上-jtds.jar包"表明了问题的核心：Kettle无法成功连接到SQL Server数据库。这通常是因为缺少适当的驱动程序，即Java数据库连接（JDBC）驱动。在Kettle中，JDBC驱动是用于与各种...
首先，jtds是一个开源的Java数据库连接器，主要支持Microsoft SQL Server和Sybase数据库。它的优点在于提供了对这些数据库的轻量级、高效率的连接，使得Java应用程序能够无缝地与SQL Server和Sybase交互。jtds的连接...
首先，JTDS（Java JDBC Driver for SQL Server）是一个开源的JDBC驱动，支持Microsoft SQL Server和Sybase数据库。相比于微软官方提供的sqljdbc.jar，JTDS在某些情况下可能更具优势，比如性能、兼容性和易用性。 在...
Jtds（Java JDBC Driver for MS SQL Server and Sybase）是一个开源的Java数据库连接器，它实现了Java Database Connectivity (JDBC) API，使得Java应用程序能够连接到Microsoft SQL Server和Sybase数据库。jtds的...
其次，通过JTDS JDBC Driver连接SQL Server数据库需要下载jtds-1.2.jar文件，该驱动支持Microsoft SQLServer（6.5、7.0、2000和2005）和Sybase，并且实现了JDBC 3.0，是免费的。驱动程序名称为...
jdbc.url=jdbc:jtds:sqlserver://localhost:1433/yourDatabase jdbc.username=yourUsername jdbc.password=yourPassword jdbc.pool.maxActive=50 jdbc.pool.minIdle=10 ``` 3. 初始化连接池：在应用程序启动...
连接sysbase: jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver jdbc.url=jdbc:jtds:sybase://ip地址:...jdbc.url=jdbc:jtds:sqlserver://ip地址:1433/数据库名称 jdbc.username=用户名 jdbc.password=密码
Oracle SQL Developer 添加SQLServer 和Sybase 连接,开始只有oracle 和access 连接,工具——>首选项——>数据库——>第三方JDBC驱动程序——>添加驱动条目,添加下载文件
标题中提到的"jtds.jar"是一个开源的Java数据库连接器（JDBC）驱动，它实现了对SQL Server和Sybase数据库的访问。jtds.jar 1.3.1版本是一个较旧但稳定的版本，适用于不少环境。在Kettle中，这个驱动用于建立与SQL ...
JTDS是一个开放源代码的100%纯Java的，用于JDBC 3.0驱动Microsoft SQL Server （6.5 ，7 ，2000和2005版本）驱动程序。在hibernate连接sqlserver数据库时最好用这个。。
"jtds sqlserver连接驱动"指的是JDBC驱动程序Jtds，它是一个开源的Java类型数据库驱动（JDBC driver），专门用于连接Microsoft SQL Server和Sybase数据库。Jtds提供了一个与Microsoft JDBC驱动程序兼容的接口，使得...
在本例中，`jtds`是一个开源的JDBC驱动，专门用于连接Microsoft SQL Server和Sybase数据库。它允许Java应用程序通过网络与SQL Server进行通信，是进行数据库迁移的桥梁。 3. jtds-1.2.2-dist：这个压缩包文件包含了...
2. **编写数据库连接代码**：创建一个类来处理与SQL Server的连接。在该类中，你需要实现打开和关闭连接、执行SQL查询以及处理结果集的方法。使用`java.sql.DriverManager`加载驱动，然后使用`DriverManager.get...
这是因为Kettle需要JDBC驱动程序（Java Database Connectivity）来与SQL Server通信，而jTDS是开源的JDBC驱动程序，专门用于连接Microsoft SQL Server和Sybase数据库。在这个情况下，jtds-1.3.1是jTDS的一个特定版本...