setServerPreparedStatementDiscardThreshold Method (SQLServerDataSource)
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
Remarks
This method is available from JDBC driver version 6.4 and onward.
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for