Pessoal, estou com problemas em configurar o hibernate xml para chamar procedure!
Segue o código:
<?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 package="br.com.fromtis.report.domain.report">
<class name="br.com.fromtis.report.domain.report.ComposicaoCarteiraFundoBean" >
<id name="id" column="ID_COMPOSICAO_CARTEIRA_FUNDO" type="long"/>
<property name="nmFundo" column="NM_FUNDO" type="string"/>
<property name="cnpj" column="NO_CNPJ" type="string"/>
<property name="cdIsin" column="CD_ISIN" type="string"/>
<property name="qtCotas" column="QT_COTAS" type="double"/>
<property name="vlNominal" column="VL_NOMINAL" type="double"/>
<property name="vlRendimento" column="VL_RENDIMENTO" type="double"/>
<property name="vlBruto" column="VL_BRUTO" type="double"/>
<property name="vlIrrf" column="VL_IRRF" type="double"/>
<property name="vlIof" column="VL_IOF" type="double"/>
<property name="vlLiquido" column="VL_LIQUIDO" type="double"/>
<property name="vlSeg" column="PC_SOBRE_SEGTO" type="double"/>
<property name="vlPl" column="PC_SOBRE_PL" type="double"/>
<property name="vlRentMes" column="VL_RENTAB_MES" type="double"/>
<property name="vlRentAno" column="VL_RENTAB_ANO" type="double"/>
</class>
<sql-query name="sp_ComposicaoCarteiraFundos" callable="true" >
<return alias="composicaoCarteiraFundoBean" class="br.com.fromtis.report.domain.report.ComposicaoCarteiraFundoBean" lock-mode="read">
<return-property name="nmFundo" column="NM_FUNDO" />
</return>
{call sp_ComposicaoCarteiraFundos(:codCliente,:data)}
</sql-query>
</hibernate-mapping>
Código java chamando procedure:
List beanList = null;
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
beanList = session.getNamedQuery("sp_ComposicaoCarteiraFundos")
.setParameter("codCliente", carteira.getCodCliente())
.setParameter("data", sFormat.format(carteira.getData()))
.list();
Erro:
[WARN ] [2010-11-19 13:27:07,593] org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class org.hibernate.exception.SQLGrammarException
Alguém pode me ajudar?