I am trying to get a bi-directional container managed relationship working
in Orion 1.5.2 but it keeps creating an intermediate table. Is there anyway
to stop this? There is no need for the extra table.

Here is my example:

Change[1]----->[*]Objection

create table change (
        change_id integer primary key
)

create table objection (
        objection_id integer primary key,
        change_id integer
)

<ejb-relation>
        <ejb-relation-name>Change-Objection</ejb-relation-name>
        <ejb-relationship-role>
        
<ejb-relationship-role-name>change-has-objections</ejb-relationship-role-nam
e>
                <multiplicity>One</multiplicity>
                <role-source>
                        <ejb-name>Change</ejb-name>
                </role-source>
                <cmr-field>
                        <cmr-field-name>objections</cmr-field-name>
                        <cmr-field-type>java.util.Set</cmr-field-type>
                </cmr-field>
        </ejb-relationship-role>
        <ejb-relationship-role>
        
<ejb-relationship-role-name>objection-belongsto-change</ejb-relationship-rol
e-name>
                <multiplicity>Many</multiplicity>
                <cascade-delete/>
                <role-source>
                        <ejb-name>Objection</ejb-name>
                </role-source>
                <cmr-field>
                        <cmr-field-name>change</cmr-field-name>
                </cmr-field>
        </ejb-relationship-role>
</ejb-relation>


******************************************************************
This e-mail is confidential and for the sole use of the intended 
recipient(s).  If you are not the intended recipient, you are not 
authorised to disclose, use, distribute or in any other way make 
use of the information contained in it, and such activities are 
prohibited.  If you have received this e-mail in error, please 
notify the sender by reply e-mail, delete the document and destroy 
all copies of the original message.
******************************************************************

Reply via email to