How to call a stored procedure using a HibernateTemplate within spring?

Question

Can someone help me call a stored procedure using a HibernateTemplate within spring? I am new to Hibernate, so please help me with this.

Thanks in advance,

Cinu Matthews

Answer 1

In Hibernate, stored procedures are just a special case of named query , and you execute named queries HibernateTemplateusing one of the following findByNamedQuery().

Answer 2

HibernateTemplate , getCurrentSession() SessionFactory getSession HibernateTemplate.

findByNameQuery(), , , - .

,

java.sql.Connection con = getSession().connection;<br>
CallableStatement statement = con.prepareCall(<your procedure>);<br>
//some setting parameter for your procedure<br>
statement.execute();