Are stored procedure calls supported in 2.1.8 or is this a feature in 3.0?
I tried to include
<sql-query name="callStoredProcedure" callable="true">{call usp_Set_Status (?, ?, ?, ?)}</sql-query>
in my mapping xml file associated to a Class but I could not figure out how
to do the call from Java.
Query storedProc = session.getNamedQuery("callStoredProcedure");
storedProc.setLong(1, batchID);
storedProc.setString(2, "N");
storedProc.setString(3, "Us100");
storedProc.setString(4, "memo");
storedProc.list();
gives me an error in execution.
|