views:

107

answers:

0

I am having issues with executing a simple sybase stored proc from hibernate. The procedure takes some input and returns one record. I tried with the following tag in hibernate mappings file and java code.

<hibernate-mapping>
<sql-query name="sybaseproc" callable="true">
  <return class="Myentity">
     <return-property name="next" column="next"/>
  </return>
  { ? = call nextnum(?,?) }
</sql-query>
</hibernate-mapping>

java code is as follows

Query q = session.getNamedQuery("sybaseproc");
q.setString(0,"test");
q.setInteger(1,new Integer(10));
Myentity entity = (Myentity) q.uniqueResult();

When I run my test. I get a error saying "Errors in Named Query sybaseproc" and the test does not run. Any help is appreciated.

Thanks

Padmanabh