Purpose

Determines whether the driver calls a user-defined function or a stored procedure when JDBC Call escape syntax ({CALL PROC_NAME(...)} or {?=CALL FUNC_NAME(...)}) is used in a SQL statement.

Valid Values

select | call| callIfNoReturn

Behavior

If set to select, the driver calls a user-defined function.

If set to call, the driver calls a stored procedure.

If set to callIfNoReturn, the driver determines whether to call a user-defined function or a stored procedure based on whether a return value parameter (?=) is specified in the JDBC Call escape syntax. If a return value parameter is specified, the driver calls a user-defined function. If not, the driver calls a stored procedure.

Data Source Methods

public String getCallEscapeBehavior()

public void setCallEscapeBehavior(String)

Default

callIfNoReturn

Data Type

String