[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6123) Patch to support Oracle Hints in Hibernate queries

[Strong Liu (JIRA)]

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

Strong Liu commented on HHH-6123:
---------------------------------

https://forum.hibernate.org/viewtopic.php?p=2382544

> Patch to support Oracle Hints in Hibernate queries
> --------------------------------------------------
>
>                 Key: HHH-6123
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6123
>             Project: Hibernate Core
>          Issue Type: Patch
>          Components: core
>    Affects Versions: 3.6.2
>            Reporter: Tad Smith
>         Attachments: hibernate-oracle-hints-patch-3.6.3-fixed.zip, hibernate-oracle-hints-patch-3.6.3.zip, hibernate-oracle-hints-patch.zip
>
>
> Supporting Oracle hints in Hibernate is a feature often requested by Hibernate users, though I'll admit should be used very rarely in practice.  Actually, I had a manager that demanded it if we were to continue using Hibernate (He was new to the project with a C++/DBA background.), so I modified Hibernate to support it.  I did this originally 2 years ago against Hibernate version 3.3.1.  I've just updated it to support Hibernate version 3.6.2.
> It would be great if this could be included in the Hibernate baseline.  It's a relatively minor change and the design follows existing Hibernate patterns.
> Thanks,
> Tad
> General Design:
> ========================
> I modeled the implementation after the org.hibernate.dialect.Dialect.getLimitString() method.  I added a new method to the org.hibernate.dialect.Dialect class called getQueryHintString().  I also modified the org.hibernate.Criteria and org.hibernate.Query interfaces to add a new method called setQueryHint().  This means you can create a Query from an HQL string and then apply the Oracle hint.
> Other Dialect class implementation would easy override the getQueryHintString() method to support hints for other databases.
> What's included in the patch:
> ===============================
> I've included the 9 classes that were modified to support Oracle hints.  I've also included a Maven POM file that should be able to generate the patch jar automatically and upload it to your Maven Repository.  Just change the artifactId from "hibernate-core" to "hibernate-core--OracleHintsPatch". (I'm relatively new to Maven and this has not received much testing, so feel free to improve upon it.)

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira