Hi,

I've read in a few posts that in order to add hints to SQL that is generated from HQL, one can use the Query.addComment() method. The problem is that the comment is added at the begininng of the query, and Oracle expects it after the SELECT keyword, e.g.

select /*+ FULL(emp_status) */ empname, status from
emp_status where status = 'P';

and this will not work:

/*+ FULL(emp_status) */ select empname, status from
emp_status where status = 'P';

does someone have a solution for this?

Thanks,
moshe.

Hi Moshe,

There is no way to specify DB-specific SQL query hints when using HQL.
There was some discussion at some point of adding it as a feature, but nothing ever came of it.
http://forum.hibernate.org/viewtopic.php?t=928724

We hit this same issue a couple of years ago with Informix. (it uses comments after SELECT to specify hints just like Oracle does)
Rather than drop back down to using SQL queries as was the suggestion we received at the time, we decided to patch Hibernate to address the issue.

FYI, we modified org.hibernate.loader.Loader as follows...

Original Code


Patched Code:


Note that as a consequence of this, we have to re-apply this patch every time we upgrade Hibernate versions.

Regards,

Frank Grimes