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:
Set the connection property responseBuffering to "adaptive" in the connection URL or
Use the setResponseBuffering method of the SQLServerStatement class or
Use the setResponseBuffering method of the SQLServerDataSource class.
Note
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 |
|---|---|
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. |
|
Describes how to set the adaptive buffering on a statement level and then retrieve a large CallableStatement OUT parameter value by using adaptive buffering. |