Pessoal isso postei no GUJ e não ninguem respondeu . Estou tentando executar uma sp via Hibernate porém esta retornando um erro:
view plain<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#>copy to clipboard<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> print<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> ?<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> 1. set ANSI_NULLS ON 2. set QUOTED_IDENTIFIER ON 3. GO 4. ALTER PROCEDURE [dbo].[sp_inserir_ua] 5. @cd_ua int, 6. @ds_ua char(30), 7. @id_ue ud_id_ue as 8. 9. INSERT INTO ua 10. VALUES (@cd_ua, @ds_ua, @id_ue ) 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 ) view plain<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#>copy to clipboard<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> print<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> ?<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> 1. @NamedNativeQuery(callable=true, name="sp_inserir_ua", resultClass = Ua.class, query = "{call sp_inserir_ua(?,?,?)}") @NamedNativeQuery(callable=true, name="sp_inserir_ua", resultClass = Ua.class, query = "{call sp_inserir_ua(?,?,?)}") view plain<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#>copy to clipboard<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> print<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> ?<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> 1. public Ua inserirUa(int cd_ua, String ds_ua, int id_ue) throwsException { 2. 3. try{ 4. 5. this.session = HibernateUtil.getSessionFactory().openSession(); 6. 7. this.tx = this.session.beginTransaction(); 8. 9. Ua ua= (Ua) this.session.getNamedQuery("sp_inserir_ua"). 10. setParameter(0, cd_ua). 11. setParameter(1, ds_ua). 12. setParameter(2, id_ue).uniqueResult(); 13. 14. return ua; 15. 16. }catch (Exception e) { 17. 18. tx.rollback(); 19. e.printStackTrace(); 20. 21. throw new Exception(); 22. } 23. finally{ 24. 25. this.session.close(); 26. } 27. } 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(); } } view plain<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#>copy to clipboard<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> print<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> ?<http://www.guj.com.br/java/246001-executar-stored-procedure-com-hibernate#> 1. java.lang.NullPointerException 2. at org.hibernate.loader.Loader.doQuery(Loader.java:720) 3. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java: 259) 4. at org.hibernate.loader.Loader.doList(Loader.java:2228) 5. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java: 2125) 6. at org.hibernate.loader.Loader.list(Loader.java:2120) 7. at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312) 8. at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722) 9. at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) 10. at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175) 11. at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java: 835) 12. at com.fozci.sicorc.persistence.UaDAO.inserirUa(UaDAO.java:70) 13. at com.fozci.sicorc.service.UaService.inserirUa(UaService.java:59) 14. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 15. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 16. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 17. at java.lang.reflect.Method.invoke(Unknown Source) 18. at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java: 421) 19. at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java: 183) 20. at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java: 1495) 21. at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java: 882) 22. at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java: 121) 23. at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158) 24. at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44) 25. at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java: 67) 26. at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java: 146) 27. at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java: 278) 28. at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:315) 29. at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 30. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 290) 31. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 206) 32. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 233) 33. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 191) 34. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 127) 35. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 102) 36. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 109) 37. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 298) 38. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) 39. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java: 588) 40. at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 41. at java.lang.Thread.run(Unknown Source) Se alguém, puder me ajudar! -- Você recebeu esta mensagem porque está inscrito na lista "flexdev" Para enviar uma mensagem, envie um e-mail para [email protected] Para sair da lista, envie um email em branco para [email protected] Mais opções estão disponíveis em http://groups.google.com/group/flexdev
