procedure calling in hibernate

[Ritesh Pareek]

Hi all,

I am facing problem regarding procedure calling in hibernate,

MySql procedure is


BEGIN

DECLARE done INT  DEFAULT 0;
DECLARE english_word  Varchar(255);
DECLARE manglish_word  Varchar(255);
DECLARE counter int(11) DEFAULT 0;
DECLARE cur1 CURSOR For Select english_meaning,manglish_variation FROM expression_descriptions
ORDER by  char_count DESC,english_meaning ASC;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET  done=1;

OPEN cur1;
REPEAT
fetch cur1 into english_word,manglish_word;
 set counter= counter+1;
  SET  str =  replace (str,english_word,manglish_word);
UNTIL done END REPEAT;
CLOSE cur1;
return str;
End

My hbm is....

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class lazy="true" name="com.monsoon.manglish.model.Translate" table="translate">
        <id column="id" name="id">
            <generator class="increment"/>
        </id>

        <property column="manglish_parameter" name="manglishParameter"/>
        <property column="english_parameter" name="englishParameter"/>
        <property column="created_at" name="createdAt"/>
        <many-to-one cascade="none"
            class="com.monsoon.manglish.model.Member"
            column="created_by"
            insert="true"
            name="createdBy"
            update="true"/>

    </class>

    <sql-query name="testSP">
        <return alias="r" class="com.monsoon.manglish.model.Translate" />
            select r.*
            from translate r
    </sql-query>

    <sql-query name="englishToManglish_SP" callable="true">
        <return alias="trans" class="com.monsoon.manglish.model.Translate">
            <return-property column="manglish_parameter" name="manglishParameter" />
        </return>
    { ? = call conv_eng(?) }
    </sql-query>

</hibernate-mapping>

Dao is function is

 public String englishToManglishTranslation(String translationPara) {

        return (String) session.getNamedQuery("englishToManglish_SP")
                .setString(1, translationPara).uniqueResult();
    }

and when i call this function ... error is

org.hibernate.MappingException: Named query not known: englishToManglish_SP
	org.hibernate.impl.AbstractSessionImpl.getNamedQuery(AbstractSessionImpl.java:70)
	org.hibernate.impl.SessionImpl.getNamedQuery(SessionImpl.java:1260)
	com.monsoon.manglish.dao.TranslationDao.englishToManglishTranslation(TranslationDao.java:39)
	com.monsoon.manglish.manager.TranslationManager.englishToManglishTranslation(TranslationManager.java:31)
	com.monsoon.manglish.controller.ExpressionController.translate(ExpressionController.java:669)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
	org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)

Please take a look.

Thanks

[David Newton]

Please ask this in the Object-Relational-Mapping forum.