String firstnameFather = "Father" + postfix;
String firstnameChild_1 = "Child_One" + postfix;
String firstnameChild_2 = "Child_Two" + postfix;
String lastname = "testStoreThreePersons_3" + postfix;
Person father = createPerson(firstnameFather, lastname, null, null);
Person child_1 = createPerson(firstnameChild_1, lastname, null, null);
Person child_2 = createPerson(firstnameChild_2, lastname, null, null);
Person[] children = new Person[]{child_1, child_2};
father.setChildren(children);
child_1.setFather(father);
child_2.setFather(father);
/*
lock childs first, then lock father
TODO: Does not pass - why? A defined lock
order necessary?
if this doesn't make sense remove the test
*/
Transaction tx = odmg.newTransaction();
tx.begin();
tx.lock(child_1, Transaction.WRITE);
tx.lock(child_2, Transaction.WRITE);
tx.lock(father, Transaction.WRITE);
tx.commit();
tx = odmg.newTransaction();
tx.begin();
// make sure all objects are retrieved freshly in subsequent transactions
((TransactionImpl) tx).getBroker().clearCache();
OQLQuery qry = odmg.newOQLQuery();
qry.create("select a from " + PersonImpl.class.getName() + " where lastname=$1");
qry.bind(lastname);
Collection result = (Collection) qry.execute();
assertEquals(3, new ArrayList(result).size());
qry = odmg.newOQLQuery();
qry.create("select a from " + PersonImpl.class.getName() + " where firstname=$1");
qry.bind(firstnameFather);
result = (Collection) qry.execute();
tx.commit();
assertEquals("Exactly one element in result set", 1, result.size());
tx.begin();
Person returnedFather = (Person) result.iterator().next();
// should retrieve new instance, cause we clear the cache
assertTrue("not same instance expected", returnedFather != father);
Person[] returnedChildren = returnedFather.getChildren();
assertNotNull(returnedChildren);
assertEquals(2, returnedChildren.length);
Person child = returnedChildren[0];
Person lookupFather = child.getFather();
assertNotNull(lookupFather);
assertEquals(returnedFather.getFirstname(), lookupFather.getFirstname());
// unfortunately, PersonImpl does not have a suitable equals method.
assertEquals(
"children's names are equal",
Arrays.asList(getFirstNames(returnedChildren)),
Arrays.asList(getFirstNames(children)));