File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
sreenivas jeenor
Ranch Hand
Posts: 125
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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




myDAO is here



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
ranger
Sheriff
Posts: 17276
6
IntelliJ IDE Mac Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic