db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Armin Waibel <arm...@apache.org>
Subject Re: odmg-api refactoring status
Date Fri, 18 Mar 2005 21:05:23 GMT
> Nope, but it's the test that is defunct probably not the code. I checked 
> in an updated version of the test to clarify my point of failure.
> 
> The two Gatherer objects are stored OK and then retrieved with this query:
> 
> "select gatherer from " + Gatherer.class.getName() + " where gatId=$1 or 
> gatId=$2";
> 
> 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";

The ID of the second one should be greater than the first one.

Armin



> 
> There is no guarantee on the returned order of these items as long as 
> there is no ORDER BY, GROUP BY or similar on the query. This testcase 
> will not be reproducable as long as no order is guaranteed. (After doing 
> some additional inserts or updates Oracle might decide to flip the two 
> again, and it's got the right to do so.)
> 
> I don't speak ODMG query language so if you could maybe fix the query?
> 
> Previous failure was on Collection but that's just because no assert was 
> made that "gat2" was in fact the second Gatherer. With my update to the 
> testcase this is asserted and thus it fails earlier. I now get:
> junit.framework.ComparisonFailure: Wrong gatherer returned: fetchedGat 
> should be first Gatherer
> Expected:
> testUpdateWhenExchangeObjectsInCollection1111178759937_Gatherer
> Actual:
> testUpdateWhenExchangeObjectsInCollection1111178759937_Gatherer2
> 
> Regards,
>  Martin
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
> 
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message