| title | setEnablePrepareOnFirstPreparedStatementCall Method (SQLServerDataSource) | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 01/19/2018 |
| ms.prod | sql |
| ms.prod_service | connectivity |
| ms.reviewer | |
| ms.suite | sql |
| ms.technology | connectivity |
| ms.tgt_pltfrm | |
| ms.topic | conceptual |
| ms.assetid | |
| caps.latest.revision | 1 |
| author | MightyPen |
| ms.author | genemi |
| manager | craigg |
[!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.
This method is available from JDBC driver version 6.4 and onward.