I am trying to call a stored procedure from hibernate but I keep getting errors. Here's what I am doing..
My table
table emp
(
ssn varchar(9),
firstname varchar(10)
)
my Employee class is
public class Employee
{
public
String ssn ;
public String firstname ;
...getter and setter methods.
}
My
test procedure in SQL SERVER is
create procedure test_proc_hibernate
as
BEGIN
select ssn,firstname from emp;
END
My hibernate mapping file the following entry
<sql-query name="testingProc" callable="true">
<return alias="empexample" class="Employee">
<return-property name="ssn" column="ssn"/>
<return-property name="firstname" column="firstname"/>
</return>
{ ? = call test_proc_hibernate() }
</sql-query>
My DAO is making the following call
session = openSession() ;
List mylist = session.getNamedQuery("testingProc").list();
CASE A)
I get the following error
org.hibernate.HibernateException: Errors in named queries: testingProc
-----------------------
CASE B)
If I change it to
<sql-query name="testingProc" callable="true">
{ ? = call test_proc_hibernate() }
</sql-query>
I get
org.hibernate.exception.SQLGrammarException: could not execute query
---------------------
CASE C)
Only this one works. But it returns a list of object type java.lang.Object.
<sql-query name="testingProc" callable="true">
{ call test_proc_hibernate() }
</sql-query>
What am I doing wrong, How can I seperate the ssn, firstname from the returned list in case (C)
Please HELP !!
