invalid column name on cmr field
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