jTDS feature matrix

Below is the list of features of jTDS 1.2.


SQL Server 2008, 2005, 2000, 7.0, 6.5 Compliant Yes
Sybase 10, 11, 12, 15 Compliant Yes (not all features available for Sybase)
JDK 1.3 Compliant Yes
Sun Certified 100% Pure JavaTM Yes

Feature Summary

Open Source and Freely Distributable Yes
Prepared and Callable Statements Yes
Updateable Result Sets Yes
Scrolling Result Sets Yes
Batch Updates Yes (fully optimized, single request/response)
Statement Pooling Yes
Full Timeout Support Yes
Full Range of Cursor Types Yes
Full BLOB and CLOB Support Yes
BLOB and CLOB Locator Support No
Unlimited Statements per Connection Yes
Generated keys retrieval Yes
Named parameters Yes
Savepoints Yes
Parameter metadata Yes
RowSet implementation No (recommended RowSet implementation: Sun reference implementation 1.0.1)
Metadata caching Yes (configurable on connection creation)

J2EE Support

JNDI Data Sources Yes
Connection Pooling Yes
Connection Pool Implementation No (recommended pool implementations: DBCP and c3p0)
XA Distributed Transactions Yes (experimental)

SQL Server-Specific

Optimized Native Protocol Performance Yes (benchmark results: [1])
Windows Authentication Yes
SQL Server named instances Yes
Ignoring of update counts from triggers Yes
Send String data as ASCII/Unicode Yes
Named Pipes Yes (using the filesystem locally and jCIFS over the network)
SSL Encryption Yes
Fast Forward-Only Cursors Yes