setEnablePrepareOnFirstPreparedStatementCall Method (SQLServerConnection)

Download JDBC driver

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