+1 for removing it On 27 July 2017 at 10:54, Vlad Mihalcea <mihalcea.v...@gmail.com> wrote:
> If we make this change, we need to make sure the StoredProcedureQuery works > properly for functions too: > > https://vladmihalcea.com/2016/04/27/how-to-call-sql-server- > stored-procedures-and-functions-from-hibernate/ > > Currently, it only supports stored procedures and not database functions. > However, users can also use session.doWork instead so there is a workaround > anyway. > > Vlad > > On Thu, Jul 27, 2017 at 11:37 AM, Arnold Gálovics < > galovicsarn...@gmail.com> > wrote: > > > Hey, > > > > @Vlad: if they eventually have to adjust their code, why is it so hard to > > use the proper API for calling stored procedures? > > > > I'm supporting Steve's idea to remove this complexity and force the users > > to use the proper API. I think for 6.0 this change can be acceptable and > > should be mentioned in the migration guide. > > > > Best Regards, > > Arnold > > > > > > > > On Thu, Jul 27, 2017 at 7:25 AM, Vlad Mihalcea <mihalcea.v...@gmail.com> > > wrote: > > > >> I run a quick Google search for "Hibernate NnativeQuery stored > procedure" > >> and found these links: > >> > >> http://www.baeldung.com/stored-procedures-with-hibernate-tutorial > >> > >> https://www.mkyong.com/hibernate/how-to-call-store-procedure > >> -in-hibernate/ > >> > >> I guess people used to do this. We could use some QueryHint which needs > to > >> be supplied when users want to execute a SP via NativeQuery. > >> I think it's less painful to have this option instead of disallowing it > >> completely. > >> > >> Vlad > >> > >> On Thu, Jul 27, 2017 at 1:08 AM, Steve Ebersole <st...@hibernate.org> > >> wrote: > >> > >> > Another unnecessary complexity I'd like discuss removing is the > ability > >> to > >> > execute procedure/function calls via NativeQuery. The complexity is a > >> > bunch of String parsing and token interpretation we need to do in > order > >> to > >> > discovery this intention. Given that both JPA and Hibernate define > >> > specific APIs for executing procedure/function calls this seems like > an > >> > unnecessary complexity and overhead. > >> > > >> > Objections? Thoughts? > >> > _______________________________________________ > >> > hibernate-dev mailing list > >> > hibernate-dev@lists.jboss.org > >> > https://lists.jboss.org/mailman/listinfo/hibernate-dev > >> > > >> _______________________________________________ > >> hibernate-dev mailing list > >> hibernate-dev@lists.jboss.org > >> https://lists.jboss.org/mailman/listinfo/hibernate-dev > >> > > > > > _______________________________________________ > hibernate-dev mailing list > hibernate-dev@lists.jboss.org > https://lists.jboss.org/mailman/listinfo/hibernate-dev > _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev