Package org.jdbi.v3.core.statement

Class Call

java.lang.Object

org.jdbi.v3.core.statement.SqlStatement<Call>

org.jdbi.v3.core.statement.Call

All Implemented Interfaces:

Closeable, AutoCloseable, Configurable<Call>

public class Call
extends SqlStatement<Call>

Used for invoking stored procedures.

Constructor Summary

Constructors

Constructor	Description
Call(Handle handle, CharSequence sql)
Call(Handle handle, String sql)	Backwards compatible constructor that takes an explicit string argument.

Method Summary

Modifier and Type	Method	Description
void	close()
ConfigRegistry	getConfig()	Returns the configuration registry associated with this object.
final StatementContext	getContext()	Returns the statement context associated with this statement.
final Handle	getHandle()
OutParameters	invoke()	Invoke the callable statement.
void	invoke(Consumer<OutParameters> resultConsumer)	Invoke the callable statement and process its OutParameters results.
<T> T	invoke(Function<OutParameters,T> resultComputer)	Invoke the callable statement and process its OutParameters results, returning a computed value of type T.
Call	registerOutParameter(int position, int sqlType)	Register a positional output parameter.
Call	registerOutParameter(int position, int sqlType, CallableStatementMapper mapper)	Register a positional output parameter.
Call	registerOutParameter(String name, int sqlType)	Register a named output parameter.
Call	registerOutParameter(String name, int sqlType, CallableStatementMapper mapper)	Register a named output parameter.

Methods inherited from class org.jdbi.v3.core.statement.SqlStatement

bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bind, bindArray, bindArray, bindArray, bindArray, bindArray, bindArray, bindArray, bindArray, bindASCIIStream, bindASCIIStream, bindBean, bindBean, bindBeanList, bindBinaryStream, bindBinaryStream, bindBySqlType, bindBySqlType, bindByType, bindByType, bindByType, bindByType, bindByType, bindByType, bindFields, bindFields, bindList, bindList, bindList, bindList, bindList, bindList, bindList, bindMap, bindMethods, bindMethods, bindMethodsList, bindNamedArgumentFinder, bindNull, bindNull, bindNVarchar, bindNVarchar, bindPojo, bindPojo, bindPojo, bindPojo, bindPojo, bindPojo, cleanupHandleCommit, cleanupHandleRollback, defineList, defineList, defineNamedBindings, setQueryTimeout, toString

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jdbi.v3.core.config.Configurable

addCustomizer, configure, define, getConfig, registerArgument, registerArgument, registerArrayType, registerArrayType, registerArrayType, registerArrayType, registerCodecFactory, registerCollector, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerExtension, registerRowMapper, registerRowMapper, registerRowMapper, registerRowMapper, setMapKeyColumn, setMapValueColumn, setSqlArrayArgumentStrategy, setSqlLogger, setSqlParser, setTemplateEngine

Constructor Details

Call

public Call(Handle handle,
 CharSequence sql)

Call

public Call(Handle handle,
 String sql)

Backwards compatible constructor that takes an explicit string argument.

See Also:

• Call(Handle, CharSequence)

Method Details

registerOutParameter

public Call registerOutParameter(int position,
 int sqlType)

Register a positional output parameter.

Parameters:

position - the parameter position (zero-based)

sqlType - an SQL type constant as defined by Types or by the JDBC vendor.

Returns:

self

registerOutParameter

public Call registerOutParameter(int position,
 int sqlType,
 CallableStatementMapper mapper)

Register a positional output parameter.

Parameters:

position - the parameter position (zero-based)

sqlType - an SQL type constant as defined by Types or by the JDBC vendor.

mapper - a mapper which converts the CallableStatement to a desired output type.

Returns:

self

registerOutParameter

public Call registerOutParameter(String name,
 int sqlType)

Register a named output parameter.

Parameters:

name - the parameter name

sqlType - an SQL type constant as defined by Types or by the JDBC vendor.

Returns:

self

registerOutParameter

public Call registerOutParameter(String name,
 int sqlType,
 CallableStatementMapper mapper)

Register a named output parameter.

Parameters:

name - the parameter name

sqlType - an SQL type constant as defined by Types or by the JDBC vendor.

mapper - a mapper which converts the CallableStatement to a desired output type.

Returns:

self

invoke

public OutParameters invoke()

Invoke the callable statement. Note that the statement will be Closeable.close()d, so cursor-typed values may not work.

Returns:

the output parameters resulting from the invocation.

invoke

public void invoke(Consumer<OutParameters> resultConsumer)

Invoke the callable statement and process its OutParameters results.

invoke

public <T> T invoke(Function<OutParameters,T> resultComputer)

Invoke the callable statement and process its OutParameters results, returning a computed value of type T.

getHandle

public final Handle getHandle()

getConfig

public ConfigRegistry getConfig()

Description copied from interface: Configurable

Returns the configuration registry associated with this object.

Specified by:

getConfig in interface Configurable<This>

Returns:

the configuration registry associated with this object.

getContext

public final StatementContext getContext()

Returns the statement context associated with this statement.

Returns:

the statement context associated with this statement.

close

public void close()

Specified by:

close in interface AutoCloseable

Specified by:

close in interface Closeable