setserverpreparedstatementdiscardthreshold-method-sqlserverdatasource.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic
setServerPreparedStatementDiscardThreshold Method (SQLServerDataSource)	setServerPreparedStatementDiscardThreshold Method (SQLServerDataSource)	David-Engel	davidengel	01/19/2018	sql	connectivity	reference

setServerPreparedStatementDiscardThreshold Method (SQLServerDataSource)

[!INCLUDEDriver_JDBC_Download]

Sets the value of serverPreparedStatementDiscardThreshold connection property. This setting controls how many outstanding prepared statement discard actions (sp_unprepare) can be outstanding per connection before a call to clean up the outstanding handles on the server is executed. When the setting is <= 1 unprepare actions are executed immediately on prepared statement close. If the value is set to > 1 these calls are batched together to avoid overhead of calling sp_unprepare too often

Syntax

public void setServerPreparedStatementDiscardThreshold(int enablePrepareOnFirstPreparedStatementCall);  

Parameters

serverPreparedStatementDiscardThreshold

The new value of the serverPreparedStatementDiscardThreshold connection property.

Exceptions

SQLServerException

Remarks

This method is available from JDBC driver version 6.4 and onward.

See Also

SQLServerDataSource Members
SQLServerDataSource Class