This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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

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)
select count(*) into res from localmap v where v.statusid=status;

here is my entity

myDAO is here

i am getting the following error

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

Joined: Feb 05, 2001
Posts: 17249

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.


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
subject: org.springframework.dao.TransientDataAccessResourceException: Hibernate operation:Callable statment
Similar Threads
Using Stored procedure in spring with hibernate
Persistence: Calling Stored Procedures from Hibernate
Calling Stored Procedure from Hibernate mapping file
Hibernate; error executing stored procedure
Problem - Call Stored procedure by Hibernate