Package org.hibernate.procedure

Defines support for executing database stored procedures and functions and accessing its outputs.

First a reference to ProcedureCall is obtained through one of the overloaded SharedSessionContract.createStoredProcedureCall(java.lang.String) methods. The ProcedureCall reference is then used to "configure" the procedure call (set timeouts, etc) and to perform parameter registration. All procedure parameters that the application wants to use must be registered. For all IN and INOUT parameters, values can then be bound.

At this point we are ready to execute the procedure call and start accessing the outputs. This is done by first calling the ProcedureCall.getOutputs()} method. The underlying JDBC call is executed as needed. The pattern to access the returns is iterating through the outputs while Outputs.goToNext()} returns true and calling Outputs.getCurrent()} during iteration: ProcedureCall call = session.createStoredProcedureCall( "some_procedure" ); ... ProcedureOutputs outputs = call.getOutputs(); while ( outputs.goToNext() ) { final Output output = outputs.getCurrent(); if ( output.isResultSet() ) { handleResultSetOutput( (ResultSetOutput) output ); } else { handleUpdateCountOutput( (UpdateCountOutput) output ); } }

Finally, output parameters can be accessed using the overloaded ProcedureOutputs.getOutputParameterValue(org.hibernate.query.procedure.ProcedureParameter<T>) methods. For portability amongst databases, it is advised to access the output parameters after all returns have been processed.

See Also:
SharedSessionContract.createStoredProcedureCall(String), SharedSessionContract.createStoredProcedureCall(String, Class[]), SharedSessionContract.createStoredProcedureCall(String, String...)