[teiid-issues] [JBoss JIRA] (TEIID-5395) Improvement of JPA translator join behavior

[Harold Campbell (JIRA)]

Harold Campbell created TEIID-5395:
--------------------------------------

             Summary: Improvement of JPA translator join behavior
                 Key: TEIID-5395
                 URL: https://issues.jboss.org/browse/TEIID-5395
             Project: Teiid
          Issue Type: Enhancement
          Components: Misc. Connectors
    Affects Versions: 10.2.1
            Reporter: Harold Campbell
            Assignee: Steven Hawkins
            Priority: Minor


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.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)