hi christophe, i could easily implement such rules for pb-api as a free form string passed to the select statement. can you please tell me the precedence of your rules and DISTINCT ?
jakob ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 25, 2002 10:35 AM 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]>
