What's New in the JDBC Driver

The following sections discuss new features in the Microsoft SQL Server 2005 JDBC Driver.

What's New in the JDBC Driver Version 1.2

This version 1.2 release of the Microsoft SQL Server 2005 JDBC Driver includes several new features and enhancements. The following sections describe the enhancements made to the JDBC driver for the version 1.2 release.

Adaptive Buffering

The JDBC driver now provides an adaptive buffering feature, which is designed to retrieve any kind of large-value data without the overhead of server cursors. For more information about how to use the adaptive buffering feature, see Using Adaptive Buffering.

The JDBC driver provides a new responseBuffering property and new streaming getter methods as part of this feature. The responseBuffering connection string property allows you to set or retrieve the adaptive buffering mode. For more information about the new responseBuffering property, see Setting the Connection Properties.

The new get<Type>Stream methods support the large value OUT parameters. For more information, see the SQLServerCallableStatement class.

SSL Encryption

The JDBC driver now provides Secure Sockets Layer (SSL) encryption to secure the communication channel with SQL Server database. For more information about how to encrypt data by using SSL, see Using SSL Encryption.

The JDBC driver provides new connection properties and new getter and setter methods as part of this feature. New connection properties are: encrypt, trustServerCertificate, trustStore, trustStorePassword, and hostNameInCertificate. For more information about how to use these new connection string properties in a Java application, see Setting the Connection Properties. For more information about how to set or get the value of these properties by using the appropriate setter and getter methods, see the SQLServerDataSource class.

Tightly Coupled XA Transactions

The JDBC driver now provides a SSTRANSTIGHTLYCPLD flag to allow the applications to use the tightly coupled XA transactions, which have different XA branch transaction IDs (XIDs) but have the same global transaction ID (GTRID). For more information, see Understanding XA Transactions.

Sample Applications

The help system for the JDBC driver includes a collection of sample applications that demonstrate various techniques for using the JDBC driver in Java applications. In this 1.2 version, the help system also provides two new additional samples that demonstrate using the adaptive buffering feature. For more information about the sample applications, see Sample JDBC Driver Applications.