Problem with accessing a CMR field, SOS

[Hussein Baghdadi]

Hi all.
I have the following cmp entity beans: TeamBean and PlayerBean
the relationship is 1 : * (one team, many players) bidirectional.
the TeamBean has to CMR field: getPlayers( ) and setPlayers(Collection)
and I have a session bean LeagueBean (session facade) and this bean has
the following method :

public Collection findPlayersWithinTeam(String teamid) {
  Collection c = null;
  try {
        TeamLocal tl = home.findByPrimaryKey(teamid);
        Collection col = tl.getPlayers( );
        /* The convert method extract every PlayerLocal from the collection
             and create a new PlayerVO object and add it to c collection
        */
        c = convert(col);
  } catch (Exception e) {
      Syste......(e.toString ( ));
  }
  return c;
}  

but when calling findPlayersWithinTeam method, nothing displayed at all,
and there is no exception.
so I think maybe because getPlayers is CMR field so I can't use it outside.
so I created the following method in TeamBean:

 
 public Collection getHisPlayers( ) throws FinderException {
  TeamLocal tl = (net.TeamLocal) ctx.getEJBLocalObject( );
  return ejbSelectPlayers(tl);
}

and the EJBQL for ejbSelectPlayers method is :
SELECT OBJECT(P) FROM TeamBean AS T, in (T.players) AS P WHERE T = ?1
and calling findPlayersWithinTeam method, nothing displayed and no exception !!
WHY ???
How can I get the players for a specific team ??
[ April 22, 2004: Message edited by: John Todd ]