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