Still a few errors being generated. I haven't had a lot of time to look into it. One issue is:
DataContextEJBQLConditionsTest.testCollectionEmpty It inserts 3 artists and 3 paintings. 2 paintings off 1 artist, 1 painting off another artist, and 1 artist with 0 paintings. It then uses: ejbql = "SELECT a FROM Artist a WHERE a.paintingArray IS EMPTY"; to create an EJBQLQuery which executes: INFO: SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2, t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON (t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL Oct 5, 2010 8:03:38 PM org.apache.cayenne.log.CommonsJdbcEventLogger logSelectCount INFO: === returned 3 rows. - took 41 ms. All 3 artists seem to be returned instead of just the 1 artist without a painting. This causes: assertEquals(1, objects.size()); to fail. I'm not sure if this is an H2 issue or something else. Obviously it seems to have happened after I updated the adapter to support auto increment PKs. :-) mrg
