is there anything wrong here ?

[Hussein Baghdadi]

Hey all.
I need your help please.
I have two CMP beans, PlayerBean and TeamBean.
the relationship is one to many and bidirectional.
TeamBean has a CMR field called plalyers and PlayerBean has a CMR field called team, and there
are a setter and getter methods for these fields in each bean.
the database schema for TeamBean is :
TEAM_NAME, TEAM_CITY
and the bean contains the following fields :
name, city
the database schema for Player bean is :
ID, FULLNAME, NAME // name is the name of the city
and the bean contained the following fields :
id, fullname, name
here is a snipet from jboss-jdbc.xml :

 
<relationships>
  <ejb-relation>
    <ejb-relation-name>Team-Player</ejb-relation-name>
    <foreign-key-mapping/>
    <ejb-relation-role>
      <ejb-relation-role-name>Team-Has-Players</ejb-relation-role-name>
      <key-fields/>
    </ejb-relation-role>
    <ejb-relation-role>
      <ejb-relation-role-name>Player-Belongs-To-Team</ejb-relation-role-name>
      <key-fields>
        <!-- what is the value of this element should be ? id or ID ? -->
        <field-name>id</field-name>
        <!-- what is the value of this element should be ? TEAM_NAME or NAME or name ? -->
        <column-name>TEAM_NAME</column-name>
      </key-fields>
    <ejb-relation-role>
  </ejb-relation>
</relationships> 

my questions are :
1. is the relationships element right ?
2. what is the value of <field-name> should be ?
id (which is the name of a field in PlayerBean class) or
ID (which is the name of the field in database schema) ?
3. what is the value of <column-name> should be ?
TEAM_NAME (which is the name of a field in Team database schema) or
NAME (which is the name of a field in Player database schema) or
name (which is the name of a field in PlayerBean class) ??
4. which sould has the <foreign-key-mapping> element , TeamBean or PlayerBean ?

[Hussein Baghdadi]

Please, this is my first week with JBoss.

[neva elsaeed]

In your ejb-jar.xml you should have something like:
-----------------------------------------------------

<ejb-relation >
<ejb-relation-name>Team-Player</ejb-relation-name>
<ejb-relationship-role >
<ejb-relationship-role-name>Player-Belongs-To-Team</ejb-relationship-role-name>
<multiplicity>Many</multiplicity>
<relationship-role-source >
<ejb-name>YourPlayerEJB</ejb-name>
</relationship-role-source>
<cmr-field >
<cmr-field-name>team</cmr-field-name>
</cmr-field>
</ejb-relationship-role>

<ejb-relationship-role >
<ejb-relationship-role-name>Team-Has-Players</ejb-relationship-role-name>
<multiplicity>One</multiplicity>
<relationship-role-source >
<ejb-name>YourTeamEJB</ejb-name>
</relationship-role-source>
<cmr-field >
<cmr-field-name>players</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
</ejb-relation>


And in your jbosscmp-jdbc.xml you should have:
-----------------------------------------------


<ejb-relation>
<ejb-relation-name>Team-Player</ejb-relation-name>

<ejb-relationship-role>
<ejb-relationship-role-name>Player-Belongs-To-Team</ejb-relationship-role-name>
<key-fields/>

</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>Team-Has-Players</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>id</field-name> <!--field name of primary key of Team table-->
<column-name>teamId</column-name> <!--field name of team id in Player table
</key-field>
</key-fields>
</ejb-relationship-role>
</ejb-relation>