Re: [hibernate-dev] 6.0 - procedure/function calls via NativeQuery

2017-07-28 Thread Steve Ebersole
I agree about the 5.x warnings. On Fri, Jul 28, 2017, 3:15 AM Sanne Grinovero wrote: > +1 to "clean this up" as it's a major release. > > Ideally, would it be possible to already introduce some warning logs > in some later 5.x ? > > Thanks, > Sanne > > > On 27 July 2017 at 15:11, Steve Ebersole

Re: [hibernate-dev] 6.0 - procedure/function calls via NativeQuery

2017-07-28 Thread Sanne Grinovero
+1 to "clean this up" as it's a major release. Ideally, would it be possible to already introduce some warning logs in some later 5.x ? Thanks, Sanne On 27 July 2017 at 15:11, Steve Ebersole wrote: > Vlad, we have had this discussion like 5 times now ;) > http://www.mail-archive.com/hibernate-

Re: [hibernate-dev] 6.0 - procedure/function calls via NativeQuery

2017-07-27 Thread Steve Ebersole
Vlad, we have had this discussion like 5 times now ;) http://www.mail-archive.com/hibernate-dev@lists.jboss.org/msg13885.html -> https://hibernate.atlassian.net/browse/HHH-10530 The ProcedureCall support for this is already mostly in place. Using your post example e.g., you'd do something like:

Re: [hibernate-dev] 6.0 - procedure/function calls via NativeQuery

2017-07-27 Thread andrea boriero
+1 for removing it On 27 July 2017 at 10:54, Vlad Mihalcea 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/ > > Curr

Re: [hibernate-dev] 6.0 - procedure/function calls via NativeQuery

2017-07-27 Thread Vlad Mihalcea
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, use

Re: [hibernate-dev] 6.0 - procedure/function calls via NativeQuery

2017-07-27 Thread Arnold Gálovics
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 i

Re: [hibernate-dev] 6.0 - procedure/function calls via NativeQuery

2017-07-27 Thread Vlad Mihalcea
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 QueryHin

[hibernate-dev] 6.0 - procedure/function calls via NativeQuery

2017-07-26 Thread Steve Ebersole
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 A