aspose file tools*
The moose likes Spring and the fly likes org.springframework.dao.TransientDataAccessResourceException: Hibernate operation:Callable statment Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "org.springframework.dao.TransientDataAccessResourceException: Hibernate operation:Callable statment" Watch "org.springframework.dao.TransientDataAccessResourceException: Hibernate operation:Callable statment" New topic
Author

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

sreenivas jeenor
Ranch Hand

Joined: Jan 09, 2005
Posts: 125

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

Joined: Feb 05, 2001
Posts: 17259
    
    6

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

Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: org.springframework.dao.TransientDataAccessResourceException: Hibernate operation:Callable statment