Modify the sql statment

[Christophe . LOMBART]

Hi all,

For performance reason, I have to add the Oracle Key word : /*+ RULE */ in
my SQL statement : How  can I do that with OJB ? The final sql statment
looks like : select /*+ RULE */  col1, col2, ... from ... where ... 

My current ojb code is :

Criteria  crit = new Criteria();
crit.addEqualTo(...);
Query q = QueryFactory.newQuery(ABBPaymentSchema.class, crit);
Iterator = broker.getIteratorByQuery(q);

Is it possible to add this "/*+ RULE*/" key word by using the Critaria or
the Query API ?


Thanks,
Christophe



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>