getserverpreparedstatementdiscardthreshold-method-sqlserverconnection.md

title	getServerPreparedStatementDiscardThreshold Method (SQLServerConnection) | Microsoft Docs
ms.custom
ms.date	01/19/2018
ms.prod	sql-non-specified
ms.prod_service	drivers
ms.service
ms.component	jdbc
ms.reviewer
ms.suite	sql
ms.technology	drivers
ms.tgt_pltfrm
ms.topic	article
apiname	SQLServerConnection.getServerPreparedStatementDiscardThreshold
apilocation	sqljdbc.jar
apitype	Assembly
ms.assetid
caps.latest.revision	1
author	MightyPen
ms.author	genemi
manager	jhubbard
ms.workload	Inactive

getServerPreparedStatementDiscardThreshold Method (SQLServerConnection)

[!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. If the setting is <= 1, un-prepare actions will be executed immediately on prepared statement close. If it is set to > 1, these calls will be batched together to avoid overhead of calling sp_unprepare too often. The default for this option can be changed by calling getDefaultServerPreparedStatementDiscardThreshold().

Syntax

  
public int getServerPreparedStatementDiscardThreshold()  

Return Value

An int that contains the value of serverPreparedStatementDiscardThreshold connection property.

Exceptions

SQLServerException

See Also

SQLServerConnection Members
SQLServerConnection Class