public interface Routine<T> extends QueryPart
Callable objects are mainly stored procedures and stored functions. The distinction between those two object types is very subtle and not well defined across various RDBMS. In general, this can be said:
Procedures:
Hence, with #852, jOOQ 1.6.8, the distinction between procedures and functions becomes obsolete. All stored routines are simply referred to as "Routine".
Modifier and Type | Method and Description |
---|---|
int |
execute()
Execute the stored object on an underlying connection
|
int |
execute(Configuration configuration)
Execute the stored object using a
Configuration object |
<Z> Z |
get(Parameter<Z> parameter) |
Catalog |
getCatalog()
Get the routine catalog.
|
List<Parameter<?>> |
getInParameters()
A list of IN parameters passed to the stored procedure as argument.
|
String |
getName()
The name of this routine
|
List<Parameter<?>> |
getOutParameters()
A list of OUT parameters passed to the stored procedure as argument.
|
Package |
getPackage()
The container package of this stored procedure or function.
|
List<Parameter<?>> |
getParameters() |
Results |
getResults() |
Parameter<T> |
getReturnParameter()
The parameter representing this routine's
getReturnValue() |
T |
getReturnValue() |
Schema |
getSchema()
Get the routine schema
|
<Z> Z |
getValue(Parameter<Z> parameter) |
<Z> void |
set(Parameter<Z> parameter,
Z value)
Set the routine's IN value for an IN parameter.
|
<Z> void |
setValue(Parameter<Z> parameter,
Z value)
Set the routine's IN value for an IN parameter.
|
Catalog getCatalog()
Schema getSchema()
String getName()
Package getPackage()
This is only supported in the SQLDialect.ORACLE
dialect.
null
if
there is no such container.Parameter<T> getReturnParameter()
getReturnValue()
null
if this routine doesn't
have a return value.getParameters()
List<Parameter<?>> getOutParameters()
getParameters()
.getParameters()
List<Parameter<?>> getInParameters()
getParameters()
.getParameters()
List<Parameter<?>> getParameters()
int execute(Configuration configuration) throws DataAccessException
Configuration
objectDataAccessException
- if something went wrong executing the queryint execute() throws DataAccessException
DataAccessException
- if something went wrong executing the query<Z> void setValue(Parameter<Z> parameter, Z value)
<Z> void set(Parameter<Z> parameter, Z value)
<Z> Z getValue(Parameter<Z> parameter)
<Z> Z get(Parameter<Z> parameter)
T getReturnValue()
Results getResults()
Copyright © 2017. All Rights Reserved.