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
-
Element Details
-
name
String name -
sqlType
int sqlType
-