sql server - JPA 2.1 stored procedure with temporary table -
i found troubles calling stored procedure using jpa 2.1.
lets assume i've got procedure looks this
create procedure [_get_agreements_by_status] @status int begin select iagreementid ,ssignature ,istatus agreement istatus = @status end
when call procedure apprication everythings work fine - recieve result set , can move on.
here snipped how looks in java
storedprocedurequery query = em.createstoredprocedurequery("_get_agreements_by_status"); query.registerstoredprocedureparameter(1, integer.class, parametermode.in); query.execute();
so far good. problem starts when need use temporary table in procedur. add temporary table procedure cant result set. more disturbing #table doesn't have part of query.
what doing wrong?
database ms sql server 2008, jpa 2.1, jdbc driver 4.0
Comments
Post a Comment