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: Atleast one role of a foreign-key
 mapped relationship must have key fields (or <primkey-field> is missing
 from ejb-jar.xml): 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