Skip to content

Latest commit

 

History

History
46 lines (35 loc) · 1.66 KB

File metadata and controls

46 lines (35 loc) · 1.66 KB
title setEnablePrepareOnFirstPreparedStatementCall 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
SQLServerConnection.setEnablePrepareOnFirstPreparedStatementCall
apilocation
sqljdbc.jar
apitype Assembly
ms.assetid
author David-Engel
ms.author v-daenge

setEnablePrepareOnFirstPreparedStatementCall Method (SQLServerConnection)

[!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.

Syntax

  
public void setEnablePrepareOnFirstPreparedStatementCall(boolean enablePrepareOnFirstPreparedStatementCall)  

Parameters

enablePrepareOnFirstPreparedStatementCall

The new value of the enablePrepareOnFirstPreparedStatementCall connection property.

Exceptions

SQLServerException

Remarks

This method is available from JDBC driver version 6.4 and onward.

See Also

SQLServerConnection Members
SQLServerConnection Class