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

[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, 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 <galovicsarnold at 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.vlad at 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 <steve at 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 at lists.jboss.org
>> > https://lists.jboss.org/mailman/listinfo/hibernate-dev
>> >
>> _______________________________________________
>> hibernate-dev mailing list
>> hibernate-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>>
>
>