Uploaded image for project: 'Hibernate ORM'
  1. HHH-6123

Patch to support Oracle Hints in Hibernate queries


    • Type: Patch
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects versions: 3.6.2
    • Fix versions: None
    • Components: hibernate-core
    • Labels:
    • Patch Reminder (view):

      Contributions and patches should be using the GitHub Fork + Pull model

    • Last commented by a user?:
    • Sprint:


      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.


      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.)


          Issue links



              • Votes:
                6 Vote for this issue
                6 Start watching this issue


                • Created: