I have a Table called | Country (primary key country_code[String]). | Trading_Centre (primary key trading_centre_code[String] & foreign key country_code[String] NOT NULL) | | | I am trying to establish a entity relationship (all tables exist, create table = false). | | TradingCentre-belongs-to-a-Country | Country-has-many-TradingCenrtes as follows (ejb-jar.xml): | | | <relationships> | | <ejb-relation> | | <ejb-relation-name>CountryEJB - TradingCentreEJB</ejb-relation-name> | | <ejb-relationship-role> | | <ejb-relationship-role-name>Country-has-many-TradingCentres</ejb-relationship-role-name> | | <multiplicity>One</multiplicity> | | <relationship-role-source> | | <ejb-name>CountryEJB</ejb-name> | | </relationship-role-source> | | </ejb-relationship-role> | | <ejb-relationship-role> | | <ejb-relationship-role-name>TradingCentre-belongs-to-a-Country</ejb-relationship-role-name> | | <multiplicity>Many</multiplicity> | | <relationship-role-source> | | <ejb-name>TradingCentreEJB</ejb-name> | | </relationship-role-source> | | <cmr-field> | | <cmr-field-name>localcountry</cmr-field-name> | | </cmr-field> | | </ejb-relationship-role> | | </ejb-relation> | | </relationships> | | | | How will the equivalent tag in jbosscmp-jdbc.xml be built (JBoss v 3.2.5). I need to use the foreign key country_code in table Trading_Centre to be used to map to the LocalCountry entity. In effect its a many-to-one unidirectional relationship. | | All my attempts so far have resulted in error's when deploying this relationship. I have the AdminDevel_323.pdf document (and associated CrimePortal example) but to no avail. | | Your help would be much appreciated. | | Cheers | -raj
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3840636#3840636 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3840636 ------------------------------------------------------- This SF.Net email sponsored by Black Hat Briefings & Training. Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
