here's a lot of examples over the net which describe how to call a stored procedure using Hibernate, however, when using Spring, the picture changes a bit.

I have a stored procedure in MySQL which I want to call: in SQL I need to write the following: It returns a row with the following: {INT},{INT},{FLOAT}

With Spring, I use the HibernateTemplate way of executing hibernate operations, I know that some of you won't like it, but this is the how the project was when I started, and I'm not so eager changing it, maybe in the future...

Currently, I have the following code in Java, which tries to call the procedure:


When I run it, I get the following Hibernate exception:


I figured that this is happening duo the fact that I didn't declare the stored procedure in hibernate. My question is: how do I declare it ? Is there a special way of declaring it in the Spring's application context file ?