[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6123) Patch to support Oracle Hints in Hibernate queries
Tad Smith (JIRA)
noreply at atlassian.com
Thu Apr 14 19:43:59 EDT 2011
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.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.
-
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
More information about the hibernate-issues
mailing list