Working with Adaptive Buffering

When you want to retrieve any kind of large-value data without the overhead of server cursors, you can use adaptive buffering, which is a new feature of the Microsoft SQL Server 2005 JDBC Driver version 1.2. With adaptive buffering, the Microsoft SQL Server 2005 JDBC Driver version 1.2 retrieves statement execution results from the SQL Server as the application needs them, rather than all at once. The driver also discards the results as soon as the application can no longer access them.

There are three ways that an application can request that statement execution should use adaptive buffering:

NoteNote:

For more information about using adaptive buffering, see Using Adaptive Buffering.

The topics in this section describe different ways that you can use to set adaptive buffering to access the data contained in a SQL Server database, and they also demonstrate different techniques for retrieving large-value data.

In This Section

Topic Description

Setting Adaptive Buffering Sample

Describes how to set the adaptive buffering in a connection string and on a statement level and then use a SQL statement to retrieve data.

Using Adaptive Buffering with Stored Procedures Sample

Describes how to set the adaptive buffering on a statement level and then retrieve a large CallableStatement OUT parameter value by using adaptive buffering.

See Also

Show: