Hi Christophe, Have a look at the org.apache.ojb.broker.accesslayer.sql.SqlGenerator interface. You might want to subclass SqlGeneratorDefaultImpl and provide your own implementation...
Regards, Lee Haw > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 25, 2002 5:35 PM > To: [EMAIL PROTECTED] > Subject: Modify the sql statment > > > 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
