| title | setEnablePrepareOnFirstPreparedStatementCall Method (SQLServerConnection) |
|---|---|
| description | setEnablePrepareOnFirstPreparedStatementCall Method (SQLServerConnection) |
| author | David-Engel |
| ms.author | davidengel |
| ms.date | 01/19/2018 |
| ms.service | sql |
| ms.subservice | connectivity |
| ms.topic | reference |
| apilocation | sqljdbc.jar |
| apiname | SQLServerConnection.setEnablePrepareOnFirstPreparedStatementCall |
| apitype | Assembly |
[!INCLUDEDriver_JDBC_Download]
Specifies the behavior for a specific connection instance. If value is false the first execution will call sp_executesql and not prepare a statement, once the second execution happens it will call sp_prepexec and actually set up a prepared statement handle. Following executions will call sp_execute. This relieves the need for sp_unprepare on prepared statement close if the statement is only executed once.
public void setEnablePrepareOnFirstPreparedStatementCall(boolean enablePrepareOnFirstPreparedStatementCall)
enablePrepareOnFirstPreparedStatementCall
The new value of the enablePrepareOnFirstPreparedStatementCall connection property.
This method is available from JDBC driver version 6.4 and onward.