Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.