org.mule.extension.db.api.param

Class StoredProcedureCall

java.lang.Object

org.mule.extension.db.api.param.QuerySettings

org.mule.extension.db.api.param.StatementDefinition<T>

org.mule.extension.db.api.param.ParameterizedStatementDefinition<StoredProcedureCall>

org.mule.extension.db.api.param.StoredProcedureCall

@XmlHints(allowTopLevelDefinition=true)
public class StoredProcedureCall
extends ParameterizedStatementDefinition<StoredProcedureCall>

The definition of the invocation to a stored procedure

Since:

4.0

Field Summary

Fields

Modifier and Type	Field and Description
protected LinkedHashMap<String,Object>	inOutParameters A Map which keys are the name of a parameter to be set on the JDBC prepared statement which is both input and output.

Fields inherited from class org.mule.extension.db.api.param.ParameterizedStatementDefinition

inputParameters

Fields inherited from class org.mule.extension.db.api.param.StatementDefinition

sql

Constructor Summary

Constructors

Constructor and Description
StoredProcedureCall()

Method Summary

Modifier and Type	Method and Description
protected StoredProcedureCall	copy() Returns a shallow copy of this instance.
Optional<Object>	getInOutParameter(String name)
Map<String,Object>	getInOutParameters()
Optional<OutputParameter>	getOutputParameter(String name)
List<ParameterType>	getOutputParameters()
StoredProcedureCall	getTemplate() Returns a globally defined definition this instance points to.

Methods inherited from class org.mule.extension.db.api.param.ParameterizedStatementDefinition

addInputParameter, findParameter, getInputParameter, getInputParameters, getParameterValues, resolveFromTemplate

Methods inherited from class org.mule.extension.db.api.param.StatementDefinition

getParameterType, getParameterTypes, getSql, setSql

Methods inherited from class org.mule.extension.db.api.param.QuerySettings

copyInto, getFetchSize, getMaxRows, getQueryTimeout, getQueryTimeoutUnit

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

inOutParameters

@Parameter
 @Optional
 @DisplayName(value="Input - Output Parameters")
 @XmlHints(allowReferences=false)
protected LinkedHashMap<String,Object> inOutParameters

A Map which keys are the name of a parameter to be set on the JDBC prepared statement which is both input and output.

Each parameter should be referenced in the sql text using a semicolon prefix (E.g: where id = :myParamName)).

The map's values will contain the actual assignation for each parameter.

Constructor Detail

StoredProcedureCall

public StoredProcedureCall()

Method Detail

copy

protected StoredProcedureCall copy()

Description copied from class: StatementDefinition

Returns a shallow copy of this instance.

Overrides:

copy in class ParameterizedStatementDefinition<StoredProcedureCall>

Returns:

getOutputParameter

public Optional<OutputParameter> getOutputParameter(String name)

getInOutParameter

public Optional<Object> getInOutParameter(String name)

getOutputParameters

public List<ParameterType> getOutputParameters()

getInOutParameters

public Map<String,Object> getInOutParameters()

getTemplate

public StoredProcedureCall getTemplate()

Description copied from class: StatementDefinition

Returns a globally defined definition this instance points to. Can be null.

Specified by:

getTemplate in class StatementDefinition<StoredProcedureCall>

Returns:

Another definition of the same type or null