0 Replies Latest reply on Apr 22, 2005 9:49 AM by aazaroff

    invalid column name on cmr field

    aazaroff Newbie

      I am sorry if there is another topic on this I tried to search and came up with nothing.

      I am trying to set up some container managed relationships for two beans. The beans work fine without the relationships but when I add them in and try to do a getXXX on the cmr field it returns the following:

      2005-04-22 09:21:54,470 INFO [STDOUT] javax.ejb.EJBException: Load failed; CausedByException is:
      ORA-00904: invalid column name

      I am using jboss 3.2.5 and am going by the admindevel pdf for 3.2.1 so there may be some syntax change I am unaware of. The data store is obviously Oracle (8.1.7).

      I have rewrote the jbosscmp-jdbc.xml and the ejb-jar.xml more times than I can count in the last 2 days. There are no deployment errors just run time errors.

      Here is the ejb-jar.xml for the beans and relations

      equiptype bean:

      jdbc:oracle:thin:@10.2.23.41:1521:posdev [andre on CTMS]
      <display-name>EquiptypeEB</display-name>
      <ejb-name>Equiptype</ejb-name>
      <local-home>possystems.ejb.client.EquiptypeLocalHome</local-home>
      possystems.ejb.client.EquiptypeLocal
      <ejb-class>possystems.ejb.client.EquiptypeBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.math.BigDecimal</prim-key-class>
      False
      <abstract-schema-name>Equiptype</abstract-schema-name>
      <cmp-field>
      <field-name>equiptypeseqid</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>equipfullname</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>equiptype</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>termtype</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>equipmentcategory</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>manufacturer</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>modeltype</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>manufacturerfamilyname</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>deployable</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>cloneterminalid</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>itemno</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>itemweight</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>createddate</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>createdby</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>modifieddate</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>modifiedby</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>comboind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>specialfunctionind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>multiapplicationind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>downloadableind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>wirelessind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>alphanumerictidind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>wirelessprovider</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>ipcommcapable</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>integratedpinpad</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>integratedprinter</field-name>
      </cmp-field>
      <primkey-field>equiptypeseqid</primkey-field>

      auto generated method
      <query-method>
      <method-name>findByEquiptypeseqid</method-name>
      <method-params>
      <method-param>java.math.BigDecimal</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.equiptypeseqid = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByEquipfullname</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.equipfullname = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByEquiptype</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.equiptype = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByTermtype</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.termtype = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByEquipmentcategory</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.equipmentcategory = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByManufacturer</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.manufacturer = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByModeltype</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.modeltype = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByManufacturerfamilyname</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.manufacturerfamilyname = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByDeployable</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.deployable = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByCloneterminalid</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.cloneterminalid = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByItemno</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.itemno = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByItemweight</method-name>
      <method-params>
      <method-param>java.math.BigDecimal</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.itemweight = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByCreatedby</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.createdby = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByModifiedby</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.modifiedby = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByComboind</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.comboind = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findBySpecialfunctionind</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.specialfunctionind = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByMultiapplicationind</method-name>
      <method-params>
      <method-param>java.math.BigDecimal</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.multiapplicationind = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByDownloadableind</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.downloadableind = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByWirelessind</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.wirelessind = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByAlphanumerictidind</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.alphanumerictidind = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByWirelessprovider</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.wirelessprovider = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByIpcommcapable</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.ipcommcapable = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByIntegratedpinpad</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.integratedpinpad = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByIntegratedprinter</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(e) FROM Equiptype AS e WHERE e.integratedprinter = ?1</ejb-ql>



      the applsetup bean

      jdbc:oracle:thin:@10.2.23.41:1521:posdev [andre on CTMS]
      <display-name>ApplsetupEB</display-name>
      <ejb-name>Applsetup</ejb-name>
      <local-home>possystems.ejb.client.ApplsetupLocalHome</local-home>
      possystems.ejb.client.ApplsetupLocal
      <ejb-class>possystems.ejb.client.ApplsetupBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.Object</prim-key-class>
      False
      <abstract-schema-name>Applsetup</abstract-schema-name>
      <cmp-field>
      <field-name>applsetupseqid</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>applicationname</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>createdby</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>createddate</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>applversion</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>businesstype</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>cvvindicator</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>modifiedby</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>modifieddate</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>applusescat</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>featureindicator</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>disablepicklist</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>exportindicator</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>downloadplatform</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>encryptionindicator</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>businesstypeusesind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>multipletransactionind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>ecacapable</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>tdsmapping</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>hostcaptureind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>configcode</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>newarchitecture</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>platformindicator</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>requesttypeseqid</field-name>
      </cmp-field>

      auto generated method
      <query-method>
      <method-name>findByApplsetupseqid</method-name>
      <method-params>
      <method-param>java.math.BigDecimal</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.applsetupseqid = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByApplicationname</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.applicationname = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByCreatedby</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.createdby = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByApplversion</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.applversion = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByBusinesstype</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.businesstype = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByCvvindicator</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.cvvindicator = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByModifiedby</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.modifiedby = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByApplusescat</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.applusescat = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByFeatureindicator</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.featureindicator = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByDisablepicklist</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.disablepicklist = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByExportindicator</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.exportindicator = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByDownloadplatform</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.downloadplatform = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByEncryptionindicator</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.encryptionindicator = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByBusinesstypeusesind</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.businesstypeusesind = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByMultipletransactionind</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.multipletransactionind = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByEcacapable</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.ecacapable = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByTdsmapping</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.tdsmapping = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByHostcaptureind</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.hostcaptureind = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByConfigcode</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.configcode = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByNewarchitecture</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.newarchitecture = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByPlatformindicator</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.platformindicator = ?1</ejb-ql>


      auto generated method
      <query-method>
      <method-name>findByRequesttypeseqid</method-name>
      <method-params>
      <method-param>java.math.BigDecimal</method-param>
      </method-params>
      </query-method>
      <ejb-ql>SELECT OBJECT(a) FROM Applsetup AS a WHERE a.requesttypeseqid = ?1</ejb-ql>



      now the relations:

      <ejb-relation>
      <ejb-relation-name>Applsetup-Equiptype</ejb-relation-name>
      <ejb-relationship-role>
      <ejb-relationship-role-name>Applsetup</ejb-relationship-role-name>
      Many
      <cascade-delete/>
      <relationship-role-source>
      <ejb-name>Applsetup</ejb-name>
      </relationship-role-source>
      <cmr-field>
      <cmr-field-name>equiptypeseqid</cmr-field-name>
      </cmr-field>
      </ejb-relationship-role>
      <ejb-relationship-role>
      <ejb-relationship-role-name>Equiptypeseqid</ejb-relationship-role-name>
      One
      <relationship-role-source>
      <ejb-name>Equiptype</ejb-name>
      </relationship-role-source>
      <cmr-field>
      <cmr-field-name>applsetup</cmr-field-name>
      <cmr-field-type>java.util.Collection</cmr-field-type>
      </cmr-field>
      </ejb-relationship-role>
      </ejb-relation>


      Here is the mapping in the jbosscmp-jdbc.xml

      <enterprise-beans>

      <ejb-name>Clientequipment</ejb-name>
      <table-name>ctms.clientequipment</table-name>


      <ejb-name>Equiptype</ejb-name>
      <table-name>ctms.equiptype</table-name>
      <cmp-field>
      <field-name>equiptypeseqid</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>equipfullname</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>equiptype</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>termtype</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>equipmentcategory</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>manufacturer</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>modeltype</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>manufacturerfamilyname</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>deployable</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>cloneterminalid</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>itemno</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>itemweight</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>createddate</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>createdby</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>modifieddate</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>modifiedby</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>comboind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>specialfunctionind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>multiapplicationind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>downloadableind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>wirelessind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>alphanumerictidind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>wirelessprovider</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>ipcommcapable</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>integratedpinpad</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>integratedprinter</field-name>
      </cmp-field>


      <ejb-name>Maintenancebyref</ejb-name>
      <table-name>ctms.Maintenancebyref</table-name>


      <ejb-name>Productref</ejb-name>
      <table-name>ctms.productref</table-name>


      <ejb-name>Equipbillcharge</ejb-name>
      <table-name>ctms.equipbillcharge</table-name>


      <ejb-name>Billmethod</ejb-name>
      <table-name>ctms.billmethod</table-name>


      <ejb-name>Networkref</ejb-name>
      <table-name>ctms.networkref</table-name>


      <ejb-name>Applsetup</ejb-name>
      <table-name>ctms.applsetup</table-name>
      <cmp-field>
      <field-name>applsetupseqid</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>applicationname</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>createdby</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>createddate</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>applversion</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>businesstype</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>cvvindicator</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>modifiedby</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>modifieddate</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>applusescat</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>featureindicator</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>disablepicklist</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>exportindicator</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>downloadplatform</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>encryptionindicator</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>businesstypeusesind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>multipletransactionind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>ecacapable</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>tdsmapping</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>hostcaptureind</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>configcode</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>newarchitecture</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>platformindicator</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>requesttypeseqid</field-name>
      </cmp-field>


      <ejb-name>Cliententitlement</ejb-name>
      <table-name>ctms.Maintenancebyref</table-name>


      </enterprise-beans>



      <ejb-relation>
      <ejb-relation-name>Applsetup-Equiptype</ejb-relation-name>
      <foreign-key-mapping/>
      <ejb-relationship-role>
      <ejb-relationship-role-name>Equiptypeseqid</ejb-relationship-role-name>
      <key-fields>
      <key-field>
      <field-name>equiptypeseqid</field-name>
      <column-name>equiptypeseqid</column-name>
      </key-field>
      </key-fields>
      </ejb-relationship-role>
      <ejb-relationship-role>
      <ejb-relationship-role-name>Applsetup</ejb-relationship-role-name>
      <key-fields/>
      </ejb-relationship-role>
      </ejb-relation>
      <ejb-relation>
      <ejb-relation-name>Applsetup-Networkref</ejb-relation-name>
      <foreign-key-mapping/>
      <ejb-relationship-role>
      <ejb-relationship-role-name>Network</ejb-relationship-role-name>
      <key-fields>
      <key-field>
      <field-name>network</field-name>
      <column-name>network</column-name>
      </key-field>
      </key-fields>
      </ejb-relationship-role>
      <ejb-relationship-role>
      <ejb-relationship-role-name>Applsetup</ejb-relationship-role-name>
      <key-fields/>
      </ejb-relationship-role>
      </ejb-relation>



      I was under the impression that the cmp engine maintained these relationship columns.

      The thing I find most disconcerting about this is that when I remove the relations and the jbosscmp-jdbc.xml file completely everything works fine. I just dont really want to have to code the relationships by hand as business methods. I have tried this already with one field and it works but I believe it to be less efficient (both in coding time and run time) than letting the container manage it.

      Thanks for any advice anyone may have for me.

      Andre