jTDS JDBC Driver (original) (raw)
Home | FAQ | Documentation | Links | License | Project Info | Download | News | Bugs | Forums
jTDS feature matrix
Below is the list of features of jTDS 1.2.
| Compliance | |
|---|---|
| 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 andc3p0) |
| 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 |