Purpose

Specifies the number of PreparedStatement executions that must occur before the driver begins using server-side prepared statements.

Valid Values

0 | x

where:

x
is a positive integer that represents the number of PreparedStatement executions.

Behavior

If set to 0, the driver uses server-side prepared statements by default.

If set to x, the driver waits till it reaches the specified number of PreparedStatement executions before using server-side prepared statements.

Example

If PrepareThreshold is set to 5, the driver will start using server-side prepared statements on the fifth execution of the same PreparedStatement object.

Data Source Methods

public Integer getPrepareThreshold()

public void setPrepareThreshold(Integer)

Default

0

Data Type

int

See also

QueryTimeout