java - How to return the generated value of a stored procedure using hibernate -

i new hibernate got scenario need call stored procedure using hibernate.i using native query call stored procedure.the code below setting parameters stored proc.and declared query in entity.

entity class:         @entity         @namednativequeries({             @namednativequery(             name = "callstoreprocedure",             query = "call sp_ins_epc_certificate_events(:bus_partner_id ,:provider_name,:provider_addr_line1,:provider_addr_line2 ,:provider_city,:provider_state,epc_certificate)",         resultclass = doepctest.class)          }) 

stored procedure:

create procedure eprmtadm.sp_ins_epc_certificate_events (           -- in epc_certificate_id integer,           in p_bus_partner_id char(6),           in p_provider_name varchar(80),           in p_provider_addr_line1 varchar(80),           in p_provider_addr_line2 varchar(80),           in p_provider_city varchar(80),           in p_provider_state char(2),           out p_epc_certificate_id integer ) 

(....insert statments sets values in proc)

set p_epc_certificate_id = identity_val_local(); 

out p_epc_certificate_id integer returns certificate_id

query query = sessionfactory.getcurrentsession().getnamedquery("callstoreprocedure").                 setparameter("bus_partner_id", "0123");                 setparameter("provider_name", "qwe");                 query.setparameter("provider_addr_line1", "asdasd");                 query.setparameter("provider_addr_line2", "aasd");                   query.setparameter("provider_city", "asd");                 query.setparameter("provider_state", "pa");                         list result = query.list(); 

as certificate_id generated value cannot set it,it return value.how can handle in hibernate.is there standard api returns out p_epc_certificate_id integer out

and identity key generated db2 when call store procedure.is there way certificate id out.i able set parameters in but.i coudnt value out.i think should pass thing like.

   procedure.registeroutparameter(epc_certificate_id , java.sql.types.integer); 

but have no idea how using query in hibernate. please suggest best way identity out. thanks.

wont certificate ?

for(int i=0; i<result.size(); i++){         doepctest doepctest = (doepctest)result.get(i);         system.out.println(doepctest.getepc_certificate_id());     }