Executar Stored procedure com Hibernate

Assuntos Gerais
#1

Estou tentando executar uma sp via Hibernate porém esta retornando um erro:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE  [dbo].[sp_inserir_ua]
                @cd_ua int,
                @ds_ua char(30),
                @id_ue ud_id_ue as

INSERT INTO ua
VALUES (@cd_ua, @ds_ua, @id_ue )
@NamedNativeQuery(callable=true, name="sp_inserir_ua", resultClass = Ua.class, query = "{call sp_inserir_ua(?,?,?)}") 
public Ua inserirUa(int cd_ua, String ds_ua, int id_ue) throws Exception {
		
		try{
			
		this.session = HibernateUtil.getSessionFactory().openSession();
		
		this.tx = this.session.beginTransaction();
		
		Ua ua= (Ua) this.session.getNamedQuery("sp_inserir_ua").
		setParameter(0, cd_ua).
		setParameter(1, ds_ua).
		setParameter(2, id_ue).uniqueResult();	
	
		return ua;
		
		}catch (Exception e) {
			
			tx.rollback();
			e.printStackTrace();
			
			throw new Exception();
		}
		finally{
			
			this.session.close();
			}		
	}
java.lang.NullPointerException
	at org.hibernate.loader.Loader.doQuery(Loader.java:720)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
	at org.hibernate.loader.Loader.doList(Loader.java:2228)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
	at org.hibernate.loader.Loader.list(Loader.java:2120)
	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722)
	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835)
	at com.fozci.sicorc.persistence.UaDAO.inserirUa(UaDAO.java:70)
	at com.fozci.sicorc.service.UaService.inserirUa(UaService.java:59)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:421)
	at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
	at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1495)
	at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:882)
	at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)
	at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
	at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)
	at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
	at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)
	at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:278)
	at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:315)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source)

Alguém Poderia ajudar?

#2

Pessoal, só pra atualizar,

estou com esse problema ainda, se alguém puder ajudar!

#3

Ninguem teve esse problema ao tentar executar sp com com Hibernate?

#4