[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2736) support for native/SQL query hints in HQL/Criteria (Oracle SELECT hints for example)

[Marek Sadlowski (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=32545#action_32545 ] 

Marek Sadlowski commented on HHH-2736:
--------------------------------------

This feature is very needed!
Otherwise development focused on assuring high performance db queries is limited to native queries.
I think that javax.persistence.Query.setHint could be used for that purpose (is there really a need for separate method Query.setQueryHint ?). 
The most important is possibility of passing index hints and lock hints. Currently Hibernate limits this method's usage to 
"org.hibernate...." hints (even lock modes hints are ignored :().  

But looking at the history of this topic (not only in this JIRa but on other forums, the main question which comes to my mind is
"Is really Hibernate team r

> support for native/SQL query hints in HQL/Criteria (Oracle SELECT hints for example)
> ------------------------------------------------------------------------------------
>
>                 Key: HHH-2736
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2736
>             Project: Hibernate Core
>          Issue Type: New Feature
>          Components: query-criteria, query-hql
>    Affects Versions: 3.2.4.sp1
>            Reporter: Adam Wozniak
>
> Hello Everybody
> In 2004 Gavin said: "I think we plan to add a Query.setQueryHint() method" (hibernate forum: http://forum.hibernate.org/viewtopic.php?p=2193761&sid=5cf2ec711851f726c700eb9f56c2866a ). But I still cannot find it in Hibernate Core/Hib. Annotation/Hib. EntityManager.
> Can this enhancement request be opened / reopened?
> It would be great for us to have such possibility. 
> Kind Regards,
> Adam Wozniak

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira