| title | setEnablePrepareOnFirstPreparedStatementCall Method (SQLServerDataSource) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 01/19/2018 | |
| ms.prod | sql-non-specified | |
| ms.prod_service | drivers | |
| ms.service | ||
| ms.component | jdbc | |
| ms.reviewer | ||
| ms.suite | sql | |
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | ||
| caps.latest.revision | 1 | |
| author | MightyPen | |
| ms.author | genemi | |
| manager | jhubbard | |
| ms.workload | Inactive |
[!INCLUDEDriver_JDBC_Download]
Specifies the behavior for a specific connection instance. If this configuration is false the first execution of a prepared statement will call sp_executesql and not prepare a statement, once the second execution happens it will call sp_prepexec and actually setup 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.