Using P6Spy I see that Oracle does:
SELECT A0.GAT_ID,A0.NAME FROM COLLECTION_GATHERER A0 WHERE A0.GAT_ID = '181' OR (A0.GAT_ID = '182')
Did you tried with
final String queryStr = "select gatherer from " + Gatherer.class.getName() + " where gatId=$1 or gatId=$2 order by gatId asc";
Hehe, then I *do* speak the query language if it's possible with pure SQL. I was not sure if some "magic" had to be applied to ensure ordering across platforms etc.
I checked in your suggested update to the testcase and now I get a green light:
[junit] Running org.apache.ojb.broker.AllTests [junit] Tests run: 620, Failures: 0, Errors: 0, Time elapsed: 186,829 s [junit] Running org.apache.ojb.odmg.AllTests [junit] Tests run: 152, Failures: 0, Errors: 0, Time elapsed: 27,578 s [junit] Running org.apache.ojb.soda.AllTests [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3,5 s [junit] Running org.apache.ojb.otm.AllTests [junit] Tests run: 79, Failures: 0, Errors: 0, Time elapsed: 24,765 s
-Go Brian, release! :)
(Doco/website updates can easily be pushed a day or a half after as discussed previously.)
Cheers, Martin
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
