This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
sreenivas jeenor
Ranch Hand
Posts: 125
  • 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: 17278
6
IntelliJ IDE Mac Spring
  • 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
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic