I want to call MySQL stored procedure using hibernate. My stored procedure has both select as well as update/insert queries with more than one tables. What is the syntax of mapping file and how we can call this stored procedure from java file using hbernate?

Hi

I think the majority of your question is answered on this page of the online reference: http://www.hibernate.org/hib_docs/reference/en/html/querysql.html

Hope it helps.