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 - SQL Server and Sybase JDBC driver 1.2.2 正式版 <br>一个Microsoft SQL Server数据库的Jdbc driver。开源的非常好用。 下载地址：http://jtds.sourceforge.net/<br><br><br>
Oracle SQL Developer 添加SQLServer 和Sybase 连接,开始只有oracle 和access 连接,工具——>首选项——>数据库——>第三方JDBC驱动程序——>添加驱动条目,添加下载文件
JTDS是一个开放源代码的100%纯Java的，用于JDBC 3.0驱动Microsoft SQL Server （6.5 ，7 ，2000和2005版本）驱动程序。在hibernate连接sqlserver数据库时最好用这个。。
jar使用说明： 驱动 对应数据库 ---------------------------------------------------------- ojdbc14.jar oracle10g oracle9i --------------------------------------...jtds-1.2.2.jar SQLServer Sybase数据库
下载JDTS驱动（支持SQL6.5,7.0,2000,...String sConn="jdbc:jtds:sqlserver://localhost:1433/ch03"; String user = "sa"; String password = "123"; conn = DriverManager.getConnection(sConn, user, password);
连接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=密码
Android 直接连接SqlServer数据库,jtds-1.2.jar，JTDS是一个开放源代码的100%纯Java的，用于JDBC 3.0驱动Microsoft SQL Server （6.5 ，7 ，2000和2005版本）和Sybase（10 ，11 ，12 ，15 版本）的驱动程序
此驱动是连接sql使用。 jtds是可以解决sql数据库和JSP程序对接的驱动程序。 jTDS是一个开放源代码的100%纯Java实现的JDBC3.0...jTDS是基于freeTDS的，并且是最快的可企业级应用的SQL Server和Sybase的JDBC驱动程序。
jconn2.jar classes12_9i2.zip jtds-1.2.jar
它用于连接 Microsoft SQL Server（6.5，7，2000，2005，2008 和 2012）和Sybase（10 ，11 ，12 ，15）。 jTDS是基于freeTDS的，并且是目前最快的可企业级应用的SQL Server和Sybase的JDBC驱动程序。 jTDS完全与JDBC...
jTDS是基于freeTDS的，并且是目前最快的可企业级应用的SQL Server和Sybase的JDBC驱动程序。它用于连接 Microsoft SQL Server（6.5，7，2000，2005，2008 和 2012）和Sybase（10 ，11 ，12 ，15）。
jTDS 是第三方开源的SQL Server/Sybase数据库的JDBC驱动程序，性能最好最稳定。适用于Microsoft SQL Server（6.5到2012年）和Sybase ASE的开源JDBC 3.0 Type 4驱动程序。jTDS是JDBC 3.0规范的完整实现，也是MS SQL ...
jtds驱动包，用于驱动Microsoft SQL Server 和Sybase的驱动程序。
支持 sybase 数据库库连接，同时此资源还支持sqlserver 数据库连接， 是纯java 开发的资源
包含MySQL、PostgreSQL、Oracle、Sybase、Microsoft SQLServer(jtds)、Microsoft SQLServer(官方)、ODBC、DB2的写法
该zip包包含DB2、MS SQLServer、Sybase、MySQL、MariaDB、PostgreSQL等数据库的Jar包：db2jcc4.jar jtds-1.3.1.jar mysql-connector-java-8.0.21.jar postgresql-42.2.14.jar postgresql-8.3-603.jdbc3.jar