getenableprepareonfirstpreparedstatementcall-method-sqlserverdatasource.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic
getEnablePrepareOnFirstPreparedStatementCall Method (SQLServerDataSource)	getEnablePrepareOnFirstPreparedStatementCall Method (SQLServerDataSource)	David-Engel	davidengel	01/19/2018	sql	connectivity	reference

getEnablePrepareOnFirstPreparedStatementCall Method (SQLServerDataSource)

[!INCLUDEDriver_JDBC_Download]

Returns the value of enablePrepareOnFirstPreparedStatementCall connection property. If this configuration returns 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.

Syntax

public boolean getEnablePrepareOnFirstPreparedStatementCall();  

Return Value

Returns the boolean value of the enablePrepareOnFirstPreparedStatementCall connection property.

Exceptions

SQLServerException

Remarks

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

See Also

SQLServerDataSource Members
SQLServerDataSource Class