Hello, It seems like I have missed something in inheritance in Cayenne.
I have one main table called "Element" with fields id (PK), name and description Another table "File" inherits from "Element" with fields ID(PK, FK on Element.id) and path. When I do a context.performIteratedQuery(new SelectQuery(Element.class)) The query I see is : SELECT t0.ID, t0.DESCRIPTION, t0.NAME, t0.TYPE, t0.ID, t0.ID, t0.PATH FROM ELEMENT t0 I tried checking and unchecking the "To Dep PK" field for the relation in ID. What did I miss ?