Hello, ist it possible with EJB 2.0 and 2 EJBs (CMP) with Compound Primary Keays to use a CMR? I tried it with Netbeans 5.5 and JBoss 4.0.4. There I got following error: | 14:52:27,539 INFO [BaseLocalProxyFactory] Bound EJB | LocalHome 'StoragePoolBean' to jndi 'local/StoragePoolBean@26869040' | 14:52:27,544 INFO [ProxyFactory] Bound EJB Home 'StoragePoolBean' to | jndi 'StoragePoolBean' | 14:52:27,551 INFO [BaseLocalProxyFactory] Bound EJB | LocalHome 'VirtualVolumeBean' to jndi 'local/VirtualVolumeBean@31649249' | 14:52:27,556 INFO [ProxyFactory] Bound EJB Home 'VirtualVolumeBean' to | jndi 'VirtualVolumeBean' | org.jboss.deployment.DeploymentException: Both roles of a relation-table | mapped relationship must have key fields: | ejb-relation-name=SP-contains-VVs | The Beans seem to be o.k., the CMR not. My config: | <?xml version="1.0" encoding="UTF-8"?> | <ejb-jar version="2.1" xmlns="http://java.sun.com/xml/ns/j2ee" | xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" | xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee | http://java.sun.com/xml/ns/j2ee/ejb-jar_2_1.xsd"> | <display-name>mda2-EJBModule</display-name> | <enterprise-beans> | <entity> | <display-name>StoragePoolEB</display-name> | <ejb-name>StoragePoolBean</ejb-name> | <home>de.virticalsolutions.vdrive.mda.StoragePoolRemoteHome | </home> | <remote>de.virticalsolutions.vdrive.mda.StoragePoolRemote | </remote> | <local-home>de.virticalsolutions.vdrive.mda.StoragePoolLocalHome | </local-home> | <local>de.virticalsolutions.vdrive.mda.StoragePoolLocal | </local> | <ejb-class>de.virticalsolutions.vdrive.mda.StoragePoolBean | </ejb-class> | <persistence-type>Container | </persistence-type> | <prim-key-class>de.virticalsolutions.vdrive.mda.StoragePoolPK | </prim-key-class> | <reentrant>false</reentrant> | <abstract-schema-name>StoragePool</abstract-schema-name> | [...] | </entity> | <entity> | <display-name>VirtualVolumeEB</display-name> | <ejb-name>VirtualVolumeBean</ejb-name> | <home>de.virticalsolutions.vdrive.mda.VirtualVolumeRemoteHome | </home> | <remote>de.virticalsolutions.vdrive.mda.VirtualVolumeRemote | </remote> | <local-home> | de.virticalsolutions.vdrive.mda.VirtualVolumeLocalHome | </local-home> | <local>de.virticalsolutions.vdrive.mda.VirtualVolumeLocal | </local> | <ejb-class>de.virticalsolutions.vdrive.mda.VirtualVolumeBean | </ejb-class> | <persistence-type>Container</persistence-type> | <prim-key-class>de.virticalsolutions.vdrive.mda.VirtualVolumePK | </prim-key-class> | <reentrant>false</reentrant> | <abstract-schema-name>VirtualVolume</abstract-schema-name> | [...] | </entity> | </enterprise-beans> | <relationships> | <ejb-relation> | <description/> | <ejb-relation-name>SP-contains-VVs</ejb-relation-name> | <ejb-relationship-role> | <ejb-relationship-role-name>SPhasVV | </ejb-relationship-role-name> | <multiplicity>One</multiplicity> | <relationship-role-source> | <ejb-name>StoragePoolBean</ejb-name> | </relationship-role-source> | <cmr-field> | <cmr-field-name>virtualVolumes</cmr-field-name> | <cmr-field-type>java.util.Collection</cmr-field-type> | </cmr-field> | </ejb-relationship-role> | <ejb-relationship-role> | <ejb-relationship-role-name>VVinSP | </ejb-relationship-role-name> | <multiplicity>Many</multiplicity> | <relationship-role-source> | <ejb-name>VirtualVolumeBean</ejb-name> | </relationship-role-source> | <cmr-field> | <cmr-field-name>storagePool</cmr-field-name> | </cmr-field> | </ejb-relationship-role> | </ejb-relation> | </relationships> | <assembly-descriptor> | [...] | </assembly-descriptor> | </ejb-jar> | =========================================================================== The Primary Keys have no fields of the same name. I also tried to write the mapping in the jbosscmp-jdbc. As you will see I used e relation-table, no forign key. But with a forign-key I got the same result. Here is my jbosscmp-jdbc.xml: | <jbosscmp-jdbc> | <relationships> | <ejb-relation> | <ejb-relation-name>SP-contains-VVs</ejb-relation-name> | <relation-table-mapping> | <table-name>storagepool_has_virtualvolumes</table-name> | </relation-table-mapping> | <ejb-relationship-role> | <ejb-relationship-role-name>SPhasVV | </ejb-relationship-role-name> | <key-fields> | <key-field> | <field-name>spID</field-name> | <column-name>storagepool</column-name> | </key-field> | <key-field> | <field-name>spSessionID</field-name> | <column-name>storagepool_session</column-name> | </key-field> | </key-fields> | </ejb-relationship-role> | <ejb-relationship-role> | <ejb-relationship-role-name>VVinSP | </ejb-relationship-role-name> | <key-fields> | <key-field> | <field-name>vvID</field-name> | <column-name>virtualvolume</column-name> | </key-field> | <key-field> | <field-name>vvSessionID</field-name> | <column-name>virtualvolume_session</column-name> | </key-field> | </key-fields> | </ejb-relationship-role> | </ejb-relation> | </relationships> | </jbosscmp-jdbc> | =========================================================================== It would be great if someone could explain me what is going wrong here. At the moment I am thinking about not using CMR and make all the relationships on my own. But I don't think that it's a good solution because it would be much more code for me... bests Sascha Effert View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4024305#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...