Package org.jdbi.v3.sqlobject.customizer

Annotation Type OutParameter

@Target(METHOD)
@Retention(RUNTIME)
@Repeatable(OutParameterList.class)
public @interface OutParameter

Declare a named out parameter on an @SqlCall annotated method. Note that you *must* include the parameter name in the SQL text to ensure that the binding is activated, this is a limitation that may be fixed at a future date. Example usage, using PostgreSQL call syntax:

   handle.execute("CREATE FUNCTION set100(OUT outparam INT) AS $$ BEGIN outparam := 100; END; $$ LANGUAGE plpgsql");

   @SqlCall("{call myStoredProc(:outparam)}")
   @OutParameter(name="outparam", sqlType = Types.INTEGER)
   OutParameters callStoredProc();
 

Required Element Summary

Required Elements

Modifier and Type	Required Element	Description
String	name
int	sqlType

Element Details

name

String name

sqlType

int sqlType