I'm not up-to-date with EJB 3.1 spec, but is it possible now to make use of @SecondaryTables together with FK relations?
Say I've got three tables, A, B, and C - each has their own PK. B has an FK relation to C and A has a FK relation to B. On bean level, I'd like to create an entity which is the sum of all attributes of A, B, and C.
With EJB 3.0, JPA requires that secondary tables contain the id of the entity (as PK). I am looking for multiple table join to be based on foreign keys - and found eclipselink. I was wondering if such feature is covered by JPA used in EJB 3.1.