setresponsebuffering-method-sqlserverstatement.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	apilocation	apiname	apitype
setResponseBuffering Method (SQLServerStatement)	setResponseBuffering Method (SQLServerStatement)	David-Engel	davidengel	01/19/2017	sql	connectivity	reference	SQLServerStatement.setResponseBuffering(String responseBufferingValue)	SQLServerStatement.setResponseBuffering(String responseBufferingValue)	Assembly

setResponseBuffering Method (SQLServerStatement)

[!INCLUDEDriver_JDBC_Download]

Sets the response buffering mode for this SQLServerStatement object to case-insensitive String full or adaptive.

Syntax

  
public final void setResponseBuffering(java.lang.String value)  

Parameters

value

A String that contains the response buffering mode. The valid mode can be one of the following case-insensitive Strings: full or adaptive.

Exceptions

SQLServerException

Remarks

adaptive specifies buffering the minimum possible data when necessary.

full specifies reading the entire result from the server at run time.

adaptive is the default value in JDBC Driver version 2.0 and 3.0. full was the default prior to JDBC Driver version 2.0.

The setResponseBuffering method allows you to override the responseBuffering connection String property for the current SQLServerStatement object. For more information about using the response buffering mode, see Using Adaptive Buffering.

If the application specifies an invalid parameter value to the setResponseBuffering method, a SQLServerException is thrown.

See Also

SQLServerStatement Members
SQLServerStatement Class
Using Adaptive Buffering