From: <glassfish_at_javadesktop.org>
Date: Wed, 13 Feb 2008 14:06:47 PST

We are using the Toplink Essentials build 58g and are wondering if we can do LEFT OUTER JOINS on a secondary table. This is the snippet from our orm.xml file:

<entity name="ClaimLineImportWrapper" class="DxCG.Java.API.ClaimLineImportWrapper">
        <table name="ClaimFact" />
        <secondary-table name="SourceDim">
                <primary-key-join-column name="id" referenced-column-name="sourceID"/>
        </secondary-table>
        <attributes>
        <id name="ID">
                <column name="id"/>
        </id>
....
        <basic name="source">
                <column name="internalCode" table="SourceDim"/>
                <enumerated>ORDINAL</enumerated>
        </basic>
...

In our claim Fact table, there is a sourceID column. That value can be populated or can be null. When it is not null, it joins to the SourceDim table.
Currently, our query is pulling back only claims that have the sourceID not null. Is there a way to make this do a left outer join, which will bring back all claims, regardless of source being populated or null?

Thanks.

Eric
[Message sent by forum member 'epenetar' (epenetar)]

http://forums.java.net/jive/thread.jspa?messageID=258849