getserverpreparedstatementdiscardthreshold-method-sqlserverdatasource.md

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

getServerPreparedStatementDiscardThreshold Method (SQLServerDataSource)

[!INCLUDEDriver_JDBC_Download]

Returns 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 this value set to > 1 these calls are batched together to avoid overhead of calling sp_unprepare too often.

Syntax

public int getServerPreparedStatementDiscardThreshold();  

Return Value

Returns the int 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