Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

2.1.6


****************

Hi !

We are using hibernate as a O/R (with oracle 9 as rdbms) on a high-volume project for a financial company. We manage more than 150,000 deals / day at a rate of 10 deals / sec.

For performance reason, we want to use oracle hint. We did patch hibernate 2.1.6 to inject, dynamically, the sql hint. But as it is not clean, we would like to implement a new Dialect to support oracle hint in HQL queries.

(1) We can not use sql native queries because we use a generic HQL query generator and it will be hard to change that and not clean
(2) Unfortunatelly, there is no "render" method in hibernate 2.1.6

I tried to look to the hibernate source, and I don't see how to inject "oracle" hint in a clean way. Any one has any idea ?

Thanx !

Yazid