| title | setServerPreparedStatementDiscardThreshold Method (SQLServerDataSource) | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 01/19/2018 |
| ms.prod | sql |
| ms.prod_service | connectivity |
| ms.reviewer | |
| ms.suite | sql |
| ms.technology | connectivity |
| ms.tgt_pltfrm | |
| ms.topic | conceptual |
| ms.assetid | |
| caps.latest.revision | 1 |
| author | MightyPen |
| ms.author | genemi |
| manager | craigg |
[!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
public void setServerPreparedStatementDiscardThreshold(int enablePrepareOnFirstPreparedStatementCall);
serverPreparedStatementDiscardThreshold
The new value of the serverPreparedStatementDiscardThreshold connection property.
This method is available from JDBC driver version 6.4 and onward.