| Home | FAQ | Documentation | Links | License | Project Info | Download | News | Bugs | Forums jTDS feature matrix Below is the list of features of jTDS 1.1.
Compliance
SQL Server 2005, 2000, 7.0, 6.5 Compliant | Yes
Sybase 10, 11, 12 Compliant | Yes (not all features available for Sybase)
JDK 1.4, 1.3 and 1.2 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
NTEXT, NCHAR and NVARCHAR Support | Yes
Named Pipes | Yes (using the filesystem locally and jCIFS over the network)
SSL Encryption | Yes
Fast Forward-Only Cursors | Yes
Project hosted by | WebRing member | Web Design Anca Sinpalean