setPoolable Method (SQLServerStatement)
Requests that a statement be pooled or not pooled.
Syntax
public void setPoolable(boolean poolable) throws SQLException
Parameters
poolable
If true, requests that the statement be pooled. If false, requests that the statement not be pooled.
Exceptions
Remarks
The value specified in the poolable parameter is a hint to the statement pool implementation indicating if the application wants the statement to be pooled. The statement pool manager decides if it will use the hint.
A statement's pool value applies to both internal statement caches implemented by the driver and external statement caches implemented by application servers and other applications.
By default, a SQLServerStatement object is not poolable when created. SQLServerPreparedStatement and SQLServerCallableStatement objects are poolable when created.
SQLServerException is thrown if this method is called on a closed statement.
isPoolable returns a value indicating if the object is poolable.
See Also
Feedback
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: https://aka.ms/ContentUserFeedback.
Submit and view feedback for