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

[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 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
>