In case anyone's curious, I've figured out how to do it by playing tricks
with OJB's parser...
q.setColumns(new String[] {"/*+RULE*/ to_char(firstName)", "lastName"};
You can't put the hint in its own "column" because then there's too many
comas, and you have to put the first column in a "no-op" function in order
to tell the parser that it's OK if it doesn't understand everything in the
column definition.
-Jim Moore
-----Original Message-----
From: Jim Moore
Sent: Saturday, August 02, 2003 3:15 PM
To: 'OJB Users List'
Subject: Oracle hints
Is there any way to specify "hints" to Oracle via OJB? eg, Tell Oracle to
use a particular index, the rule-based engine, etc.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
