| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | apilocation | apiname | apitype |
|---|---|---|---|---|---|---|---|---|---|---|
getServerPreparedStatementDiscardThreshold Method (SQLServerConnection) |
getServerPreparedStatementDiscardThreshold Method (SQLServerConnection) |
David-Engel |
davidengel |
01/19/2018 |
sql |
connectivity |
reference |
sqljdbc.jar |
SQLServerConnection.getServerPreparedStatementDiscardThreshold |
Assembly |
[!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, unprepare actions are executed immediately on prepared statement close. If it's set to > 1, these calls are batched together to avoid overhead of calling sp_unprepare too often. The default for this option can be changed by calling getDefaultServerPreparedStatementDiscardThreshold().
public int getServerPreparedStatementDiscardThreshold()
An int that contains the value of serverPreparedStatementDiscardThreshold connection property.
This method is available from JDBC driver version 6.4 and onward.