Hibernate XML e procedure

0 respostas
C

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?

Criado 19 de novembro de 2010
Respostas 0
Participantes 1