What Is jTDS - JDBC Driver for SQL Server?

Q

What is jTDS - JDBC Driver for SQL Server and Sybase?

✍: FYIcenter.com

A

jTDS (Java Tabular Data Stream) is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005, 2008 and 2012) and Sybase Adaptive Server Enterprise (10, 11, 12 and 15). jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for SQL Server and Sybase ASE. 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.

Releases of jTDS - JDBC Driver for SQL Server:

1.3.1 	2013-06-08  	 
1.2.8 	2013-06-08  
1.3.0 	2012-10-27  
1.2.7 	2012-10-27  
1.2.6 	2012-09-07 
1.2.5 	2010-01-11  
1.2.4 	2009-09-29  
1.2.3 	2009-09-16 
1.2.2 	2007-08-22  
1.2.1 	2007-07-12  
1.2 	2005-11-08  
1.1 	2005-06-16 
1.0.3 	2005-04-15 
1.0.2 	2005-02-15 
1.0.1 	2005-02-09 
1.0 	2005-01-25 

For more information, see jTDS Website.

 

Downloading jTDS - JDBC Driver for SQL Server

⇒⇒FAQ for jTDS - JDBC Driver for SQL Server

2016-11-26, 2550👍, 0💬