We have an entity bean for airline fares, each of which relates to two
airports (departure and destination). We have tried to describe these
relationships using the CMP 2.x features, by specifying two ejb-relations,
"fare-departureairport" and "fare-destinationairport", in the ejb-jar.xml
file.
The CMP code tries to name both of the foreign key columns in the "Fare"
table "airport_code", hence the creation of the fare table fails. We have
tried overriding the column names in jbosscmp-jdbc.xml with no success. I
have attached an excerpt from our ejb-jar.xml; any pointers gratefully
received :)
Stephen Lewis
<ejb-relation>
<ejb-relation-name>fare-departureairport</ejb-relation-name>
<ejb-relationship-role>
<ejb-relationship-role-name>fare-has-departureairport</ejb-relationship-role
-name>
<multiplicity>Many</multiplicity>
<relationship-role-source>
<ejb-name>Fare</ejb-name>
</relationship-role-source>
<cmr-field>
<cmr-field-name>departureAirport</cmr-field-name>
</cmr-field>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>departureairport-belongs-to-fares</ejb-relations
hip-role-name>
<multiplicity>One</multiplicity>
<relationship-role-source>
<ejb-name>Airport</ejb-name>
</relationship-role-source>
</ejb-relationship-role>
</ejb-relation>
<ejb-relation>
<ejb-relation-name>fare-destinationairport</ejb-relation-name>
<ejb-relationship-role>
<ejb-relationship-role-name>fare-has-destinationairport</ejb-relationship-ro
le-name>
<multiplicity>Many</multiplicity>
<relationship-role-source>
<ejb-name>Fare</ejb-name>
</relationship-role-source>
<cmr-field>
<cmr-field-name>destinationAirport</cmr-field-name>
</cmr-field>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>destinationairport-belongs-to-fares</ejb-relatio
nship-role-name>
<multiplicity>One</multiplicity>
<relationship-role-source>
<ejb-name>Airport</ejb-name>
</relationship-role-source>
</ejb-relationship-role>
</ejb-relation>
</relationships>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
