Hi,

I'd like to know if it's possible to insert oracle sql hints in HQL.

Like:
Query query = session.createQuery("select /* CHOOSE */ teste from iqTeste as teste ");

I know it's possible do it in sqlquery:
Query query = session.createSQLQuery("select /* CHOOSE */ {teste.*} from iqusuario {teste} ", "teste", iqTeste.class);

But in sqlqueries I can't do iteration and it's very import to me.

Thank's

Rogerio Baldini.

seems like gavin says no, but in the future...
Use the forum search:
http://forum.hibernate.org/viewtopic.ph ... hint+query

You might use an oracle session parameter to switch to the CHOOSE optimizer mode : alter session set optimizer_mode='choose'

That way all your queries would use this optimizer mode.

HTH. Alain