setServerPreparedStatementDiscardThreshold Method (SQLServerConnection)
Specifies the behavior for a specific connection instance. 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 un-prepare 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(boolean thresholdValue)
Parameters
thresholdValue
The new value of the serverPreparedStatementDiscardThreshold connection property.
Exceptions
Remarks
This method is available from JDBC driver version 6.4 and onward.
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Binnenkort beschikbaar: In de loop van 2024 zullen we GitHub-problemen geleidelijk uitfaseren als het feedbackmechanisme voor inhoud en deze vervangen door een nieuw feedbacksysteem. Zie voor meer informatie:Feedback verzenden en weergeven voor