The behavior of the JPA connector has a number of issues regarding entity relationships.
- Implicit joins (those needed to get child entity id's) are made INNER JOINS, preventing getting any rows where the value would be null.
- Something odd is done with *ToMany relationships which blows up the size of resultsets.
- If a parent entity and a child entity use the same name for their id property, only one gets mapped.
- It's not possible to join the same entity more than once.