Thanks for your patience. Every relation-role exists and seem ok in my eyes (xml below). Since this looks ok i suspect my code. The Tripstatus does not have any xdoclet tag to trip, since trips relation to tripstatus is unidirectional. Trip still contains this on the getTripStatus() method: * @ejb.interface-method view-type="local" * @ejb.relation * name="tripstatus-cmp20-trip-cmp20" * role-name="trip-cmp20-has-tripstatus-cmp20" * target-role-name="tripstatus-cmp20-has-trip-cmp20" * target-ejb="Tripstatus" * @jboss.relation-mapping style="foreign-key" * @jboss.relation * fk-column="tripstatusid" * related-pk-field="tripstatusid" */
I really appreciates your help and time. Its really frustrating not to discover a solution - i dont know how many hours i've spent on this :) *sigh* -Jon The jbosscmp-jdbc.xml looks like this: ---------------------------------------- <ejb-relation> <ejb-relation-name>tripstatus-cmp20-trip-cmp20</ejb-relation-name> <foreign-key-mapping/> <ejb-relationship-role> <ejb-relationship-role-name>trip-cmp20-has-tripstatus-cmp20</ejb-relationship-role-name> </ejb-relationship-role> <ejb-relationship-role> <ejb-relationship-role-name>tripstatus-cmp20-has-trip-cmp20</ejb-relationship-role-name> <key-fields> <key-field> <field-name>tripstatusid</field-name> <column-name>tripstatusid</column-name> </key-field> </key-fields> </ejb-relationship-role> </ejb-relation> The ejb-jar.xml looks like this: ---------------------------------------- <ejb-relation > <ejb-relation-name>tripstatus-cmp20-trip-cmp20</ejb-relation-name> <ejb-relationship-role > <ejb-relationship-role-name>trip-cmp20-has-tripstatus-cmp20</ejb-relationship-role-name> <multiplicity>One</multiplicity> <relationship-role-source > <ejb-name>Trip</ejb-name> </relationship-role-source> <cmr-field > <cmr-field-name>tripstatus</cmr-field-name> </cmr-field> </ejb-relationship-role> <ejb-relationship-role > <ejb-relationship-role-name>tripstatus-cmp20-has-trip-cmp20</ejb-relationship-role-name> <multiplicity>One</multiplicity> <relationship-role-source > <ejb-name>Tripstatus</ejb-name> </relationship-role-source> </ejb-relationship-role> </ejb-relation> ------------------------------------------------------- This SF.NET email is sponsored by: Geek Gift Procrastinating? Get the perfect geek gift now! Before the Holidays pass you by. T H I N K G E E K . C O M http://www.thinkgeek.com/sf/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user