First, are multiple JOIN clauses supported? (Sanity check) I have a set of classes, BinaryResourceReference, BinaryResourceLocale and BinaryResourceContent. One BinaryResourceReference may have many BinaryResourceLocales, and each BinaryResourceLocale has one BinaryResourceContent.
I find that if I do a JPA query for BinaryResourceReference and JOIN FETCH its BinaryResourceLocales, then the content field of each BinaryResourceLocale is null and won't be lazy-loaded. If I take another approach and try to join all the way through, with this query: SELECT ref FROM BinaryResourceReference ref JOIN ref.locales locales JOIN locales.content WHERE ref.scope = ?1 AND ref.path = ?2 AND ref.extension = ?3 then I get this exception: Caused by: <openjpa-1.0.0-r420667:568756 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Encountered "JOIN locales . content WHERE" at character 70, but expected: [".", "ABS", "ALL", "AND", "ANY", "AS", "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "EMPTY", "ESCAPE", "EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "IN", "INNER", "IS", "JOIN", [snip] Presumably this is happening either because multiple joins aren't allowed, or I'm doing them the wrong way for this case. I suspect it's the latter, because the parser claims to have been expecting JOIN. I've double-checked the field names just to be sure. BinaryResourceReference#locales is a 1:M to BinaryResourceReferenceLocales, and BinaryResourceReferenceLocales#content is a 1:1 to BinaryResourceContent. Any thoughts or suggestions? Nick -- "Courage isn't just a matter of not being frightened, you know. It's being afraid and doing what you have to do anyway." Doctor Who - Planet of the Daleks This message has been brought to you by Nick Johnson 2.3b1 and the number 6. http://healerNick.com/ http://morons.org/ http://spatula.net/