| title | getEnablePrepareOnFirstPreparedStatementCall Method (SQLServerConnection) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 01/19/2018 | |
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.reviewer | ||
| ms.technology | connectivity | |
| ms.topic | conceptual | |
| apiname |
|
|
| apilocation |
|
|
| apitype | Assembly | |
| ms.assetid | ||
| author | David-Engel | |
| ms.author | v-daenge |
[!INCLUDEDriver_JDBC_Download]
Returns the value of enablePrepareOnFirstPreparedStatementCall connection property. If 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. The default for this option can be changed by calling setDefaultEnablePrepareOnFirstPreparedStatementCall().
public boolean getEnablePrepareOnFirstPreparedStatementCall()
A boolean that contains the value of enablePrepareOnFirstPreparedStatementCall connection property.
This method is available from JDBC driver version 6.4 and onward.