*/

                    Project project = new Project();

                    project.setTitle(title);

                    List l1 = new ArrayList();

                    l1.add(project);

                    List l2 = new ArrayList();

                    l2.add(project);

                    Role r1 = new Role();

                    r1.setPerson(p1);

                    r1.setRoleName(title);

                    r1.setProject(project);

                    List roles1 = new ArrayList();

                    roles1.add(r1);

                    Role r2 = new Role();

                    r2.setPerson(p2);

                    r2.setRoleName(title);

                    r2.setProject(project);

                    List roles2 = new ArrayList();

                    roles2.add(r2);

                    p1.setRoles(roles1);

                    Object obj = ClassHelper.newInstance(targetTestClass);

                    broker.beginTransaction();

                    broker.store(obj);

  {

    resetStmtCount();

    myPB.clearCache();

    myPB.beginTransaction();

    myPB.store(pers);

    //SELECT A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM OJB_HL_SEQ A0 WHERE (A0.TABLENAME LIKE  'SEQ_PERSON' ) AND A0.FIELDNAME LIKE  'ID'

    //SELECT VERSION,GRAB_SIZE,MAX_KEY,FIELDNAME,TABLENAME FROM OJB_HL_SEQ WHERE TABLENAME = 'SEQ_PERSON'  AND FIELDNAME = 'ID'

    //UPDATE OJB_HL_SEQ SET MAX_KEY='150',GRAB_SIZE='20',VERSION='7' WHERE TABLENAME = 'SEQ_PERSON'  AND FIELDNAME = 'ID'  AND VERSION = '6'

    // commit|

    //SELECT LASTNAME,FIRSTNAME,ID FROM PERSON WHERE ID = '131'

    //INSERT INTO PERSON (ID,FIRSTNAME,LASTNAME) VALUES ('131','','')

    logStmtCount("Storing first person");  // 6. oma: why so many? double lookup in OJB_HL_SEQ !

    resetStmtCount();

    myPB.store(pers, ObjectModification.INSERT);

    myPB.commitTransaction();

    // INSERT INTO PERSON (ID,FIRSTNAME,LASTNAME) VALUES ('172','','')

    // commit

    assertStmtCount("insert second Person with empty collection.", 2);

  {

    resetStmtCount();

    myPB.clearCache();

    myPB.beginTransaction();

    Project proj = new Project();

    proj.setTitle("testPersonSingleProjectInsert(1)");

    myPB.store(pers);

    myPB.store(proj);

    logStmtCount("Storing first person and first project");

    // 12. oma: why so many? double lookup in OJB_HL_SEQ !

    resetStmtCount();

    Project proj2 = new Project();

    proj2.setTitle("proj2");

    Collection projects = Arrays.asList(new Project[] {proj2});

    myPB.store(pers, ObjectModification.INSERT);

    myPB.commitTransaction();

    // INSERT INTO PERSON (ID,FIRSTNAME,LASTNAME) VALUES ('292','','')

    // SELECT TITLE,DESCRIPTION,ID FROM PROJECT WHERE ID = '88'

    // INSERT INTO PROJECT (ID,TITLE,DESCRIPTION) VALUES ('88','proj2','')

  {

    resetStmtCount();

    myPB.clearCache();

    myPB.beginTransaction();

    myPB.store(pers);

    //SELECT A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM OJB_HL_SEQ A0 WHERE (A0.TABLENAME LIKE  'SEQ_PERSON' ) AND A0.FIELDNAME LIKE  'ID'

    //SELECT VERSION,GRAB_SIZE,MAX_KEY,FIELDNAME,TABLENAME FROM OJB_HL_SEQ WHERE TABLENAME = 'SEQ_PERSON'  AND FIELDNAME = 'ID'

    //UPDATE OJB_HL_SEQ SET MAX_KEY='150',GRAB_SIZE='20',VERSION='7' WHERE TABLENAME = 'SEQ_PERSON'  AND FIELDNAME = 'ID'  AND VERSION = '6'

    // commit|

    //SELECT LASTNAME,FIRSTNAME,ID FROM PERSON WHERE ID = '131'

    //INSERT INTO PERSON (ID,FIRSTNAME,LASTNAME) VALUES ('131','','')

    logStmtCount("Storing first person");  // 6. oma: why so many? double lookup in OJB_HL_SEQ !

    resetStmtCount();

    myPB.store(pers, ObjectModificationDefaultImpl.INSERT);

    myPB.commitTransaction();

    // INSERT INTO PERSON (ID,FIRSTNAME,LASTNAME) VALUES ('172','','')

    // commit

    assertStmtCount("insert second Person with empty collection.", 2);

  {

    resetStmtCount();

    myPB.clearCache();

    myPB.beginTransaction();

    Project proj = new Project();

    proj.setTitle("testPersonSingleProjectInsert(1)");

    myPB.store(pers);

    myPB.store(proj);

    logStmtCount("Storing first person and first project");

    // 12. oma: why so many? double lookup in OJB_HL_SEQ !

    resetStmtCount();

    Project proj2 = new Project();

    proj2.setTitle("proj2");

    Collection projects = Arrays.asList(new Project[] {proj2});

    myPB.store(pers, ObjectModificationDefaultImpl.INSERT);

    myPB.commitTransaction();

    // INSERT INTO PERSON (ID,FIRSTNAME,LASTNAME) VALUES ('292','','')

    // SELECT TITLE,DESCRIPTION,ID FROM PROJECT WHERE ID = '88'

    // INSERT INTO PROJECT (ID,TITLE,DESCRIPTION) VALUES ('88','proj2','')

    super.setUp();

    resetStmtCount();

    myPB = PersistenceBrokerFactory.defaultPersistenceBroker();

    myPB.beginTransaction();

    myPB.store(a);

    aId = new Identity(a, myPB);

    myPB.commitTransaction();

    logStmtCount("Wrote test data");

  }

    myPB.clearCache();

    logger.info("begin txn");

    myPB.beginTransaction();

    logger.info("retrieving person");

    // SELECT ... FROM PERSON WHERE ID = ..

    // SELECT ... FROM PERSON_PROJECT WHERE PERSON_ID = ..

    // SELECT ... FROM PROJECT, PERSON_PROJECT WHERE ...

    logger.info("comitting txn");

    // COMMIT

    resetStmtCount();

    myPB.clearCache();

    logger.info("begin txn");

    myPB.beginTransaction();

    assertStmtCount("retrieve Person by Identity", 3);

    resetStmtCount();

    assertSame(a, b);

    assertStmtCount("retrieve Person 2nd time", 0);

    myPB.commitTransaction();

  }

    resetStmtCount();

    myPB.clearCache();

    logger.info("begin txn");

    myPB.beginTransaction();

    assertStmtCount("retrieve Person by Identity", 3);

    resetStmtCount();

    logger.info("accessing projects");

    assertEquals(0, c.size());

    assertStmtCount("accessing non-proxy collection", 0);

    assertStmtCount("accessing proxy-collection", 0);

    assertEquals(0, d.size());

    myPB.commitTransaction();

  }