Package org.jdbi.v3.core.statement

Class Call

java.lang.Object

org.jdbi.v3.core.statement.BaseStatement<This>

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.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
private class	Call.OutParamArgument

Nested classes/interfaces inherited from class org.jdbi.v3.core.statement.BaseStatement

BaseStatement.StatementCustomizerInvocation

Field Summary

Fields

Modifier and Type	Field	Description
private final List<Call.OutParamArgument>	params

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

stmt

Fields inherited from class org.jdbi.v3.core.statement.BaseStatement

typedThis

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
(package private) PreparedStatement	createStatement(String parsedSql)
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

afterExecution, beforeBinding, beforeExecution, beforeTemplating, 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, bindNamedArgumentFinder, bindNull, bindNull, bindNVarchar, bindNVarchar, bindPojo, bindPojo, bindPojo, bindPojo, bindPojo, bindPojo, cleanupHandleCommit, cleanupHandleRollback, cleanupStatement, defineList, defineList, defineNamedBindings, getBinding, getSql, internalExecute, mapperForType, mapperForType, mapperForType, parseSql, setQueryTimeout, toString

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

addCustomizers, attachToHandleForCleanup, callCustomizers, cleanUpForException, close, equals, getConfig, getContext, getHandle, hashCode

Methods inherited from class java.lang.Object

clone, finalize, getClass, 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, registerCollector, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerColumnMapper, registerExtension, registerRowMapper, registerRowMapper, registerRowMapper, registerRowMapper, setMapKeyColumn, setMapValueColumn, setSqlArrayArgumentStrategy, setSqlLogger, setSqlParser, setTemplateEngine, setTimingCollector

Field Details

params

private final List<Call.OutParamArgument> params

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

createStatement

PreparedStatement createStatement(String parsedSql)
                           throws SQLException

Overrides:

createStatement in class SqlStatement<Call>

Throws:

SQLException

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 cleaned up, 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.