Edit

getEnablePrepareOnFirstPreparedStatementCall Method (SQLServerDataSource)

  • Article

Download JDBC driver

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