org.springframework.dao.TransientDataAccessResourceException: Hibernate operation:Callable statment

[sreenivas jeenor]

here is my procedure in Mysql

DROP PROCEDURE IF EXISTS ers_schema.GetLocReport;
CREATE PROCEDURE ers_schema.`GetLocReport`(OUT res int,IN status int)
BEGIN
select count(*) into res from localmap v where v.statusid=status;
END;

here is my entity

 import java.io.Serializable;  
         import java.util.Date;  
      
         import javax.persistence.Column;     
         import javax.persistence.Entity;  
         import javax.persistence.GeneratedValue;  
         import javax.persistence.Id;  
         import javax.persistence.Table;  
         import org.hibernate.annotations.NamedNativeQuery;  
    
         @Entity  
         @Table(name="localmap")  
         @NamedNativeQuery( callable = true, name = "GetLocReport", query = "call   
         GetLocReport(?, :status)", readOnly = true, resultClass = 
         LocalConveyance.class)   
         
         public class localmap implements Serializable{  
         ....  
         }  

myDAO is here

  public List<LocalConveyance> getLocalProcTest(final int status)throws    

            DataAccessException,SQLException{   
    			  
    		return (List<LocalConveyance>) getHibernateTemplate().execute(new   
                HibernateCallback() {  
    		    public Object doInHibernate(final Session session) throws   
                HibernateException, SQLException {  
    		      return session.getNamedQuery("GetLocReport") //  
    		                    .setParameter("status", status)  
    		                    .list(); //  
    		                      
    		    }   
    		  });  
		
	      }   

i am getting the following error

org.springframework.dao.TransientDataAccessResourceException: Hibernate
operation:
could not execute query; SQL [call GetLocReport(?, ?)]; Callable statments
not supported.; nested exception is java.sql.SQLException: Callable
statments not supported.

[Mark Spritzler]

So it is saying that it doesn't support callable statements.

What version of HIbernate are you using?
If 3.1 or higher you should not be using HibernateTemplate.

I don't really think this is a Spring problem, but more Hibernate and the database that you are using, and maybe something in how you set it up and coded. But I can't be sure.

Mark