0 Replies Latest reply on Aug 4, 2006 5:11 AM by Yura Kravchuk

    updating entity bean not updates field in database

    Yura Kravchuk Newbie

      The entity bean doesn't update field in database.
      I have two entity beans OrgPersonnel and QualificationName. OrgPersonnel has field qualificationNameId (N:1 relation).

      For these entity beans in jboss.xml file specified different container configurations. The OrgPersonnel bean's configuration is 'Instance Per Transaction CMP 2.x EntityBean'. The QualificationName bean's configuration is 'Standard CMP 2.x EntityBean with cache invalidation' but with commit-option 'D'.
      When I am changing OrgPersonnel entity bean then changes affects all fields for corresponding record in database except qualificationNameId field, but it was changed. I examined the query that Jboss produced and found that field qualificationNameId missed in update.

      I tried it on JBoss 4.0.3SP1, 4.0.4.GA

      2006-08-04 11:35:34,851 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.OrgPersonnelEJB] Executing SQL:
      UPDATE org_personnels SET family_name=?, family_name_prefix=? WHERE org_personnel_id=?
      


      I tried update other entities with similar configurations but all works properly.

      If I use default configuration 'Standard CMP 2.x EntityBean' for OrgPersonnel entity bean then qualificationNameId field appears in update query and changes in database.

      ejb-jar.xml
       <entity>
       <ejb-name>OrgPersonnelEJB</ejb-name>
       <local-home>com.usl.smash.data.orgPersonnel.LocalOrgPersonnelHome</local-home>
       <local>com.usl.smash.data.orgPersonnel.LocalOrgPersonnel</local>
       <ejb-class>com.usl.smash.data.orgPersonnel.OrgPersonnelBean</ejb-class>
       <persistence-type>Container</persistence-type>
       <prim-key-class>java.lang.Integer</prim-key-class>
       <reentrant>False</reentrant>
       <cmp-version>2.x</cmp-version>
       <abstract-schema-name>org_personnels</abstract-schema-name>
       <cmp-field>
       <field-name>orgPersonnelId</field-name>
       </cmp-field>
      <cmp-field>
      <field-name>number</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>qualificationNameId</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>organizationId</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>familyName</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>familyNamePrefix</field-name>
      </cmp-field>
       <primkey-field>orgPersonnelId</primkey-field>
       <query>
       <query-method>
       <method-name>ejbSelectGeneric</method-name>
       <method-params>
       <method-param>java.lang.String</method-param>
       <method-param>java.lang.Object[]</method-param>
       </method-params>
       </query-method>
       <ejb-ql/>
       </query>
       <query>
       <query-method>
       <method-name>ejbSelectCountGeneric</method-name>
       <method-params>
       <method-param>java.lang.String</method-param>
       <method-param>java.lang.Object[]</method-param>
       </method-params>
       </query-method>
       <ejb-ql/>
       </query>
       </entity>
      
      <entity>
      <ejb-name>QualificationNameEJB</ejb-name>
      <local-home>com.usl.smash.data.qualificationName.LocalQualificationNameHome</local-home>
      <local>com.usl.smash.data.qualificationName.LocalQualificationName</local>
      <ejb-class>com.usl.smash.data.qualificationName.QualificationNameBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.Integer</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-version>2.x</cmp-version>
      <abstract-schema-name>qualification_names</abstract-schema-name>
      <cmp-field>
      <field-name>qualificationNameId</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>name</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>standard</field-name>
      </cmp-field>
      <primkey-field>qualificationNameId</primkey-field>
      <query>
      <query-method>
      <method-name>ejbSelectGeneric</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      <method-param>java.lang.Object[]</method-param>
      </method-params>
      </query-method>
      <ejb-ql/>
      </query>
      <query>
      <query-method>
      <method-name>ejbSelectCountGeneric</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      <method-param>java.lang.Object[]</method-param>
      </method-params>
      </query-method>
      <ejb-ql/>
      </query>
      </entity>
      
      <ejb-relationship-role>
      <ejb-relationship-role-name>QualificationName-has-OrgPersonnels</ejb-relationship-role-name>
      <multiplicity>One</multiplicity>
      <relationship-role-source>
      <ejb-name>QualificationNameEJB</ejb-name>
      </relationship-role-source>
      <cmr-field>
      <cmr-field-name>orgPersonnels</cmr-field-name>
      <cmr-field-type>java.util.Collection</cmr-field-type>
      </cmr-field>
      </ejb-relationship-role>
      <ejb-relationship-role>
      <ejb-relationship-role-name>OrgPersonnel-is-QualificationName</ejb-relationship-role-name>
      <multiplicity>Many</multiplicity>
      <cascade-delete/>
      <relationship-role-source>
      <ejb-name>OrgPersonnelEJB</ejb-name>
      </relationship-role-source>
      <cmr-field>
      <cmr-field-name>qualificationName</cmr-field-name>
      </cmr-field>
      </ejb-relationship-role>
      </ejb-relation>
      


      jbosscmp-jdbc.xml
      <entity>
      <ejb-name>OrgPersonnelEJB</ejb-name>
      <table-name>org_personnels</table-name>
      <cmp-field>
      <field-name>orgPersonnelId</field-name>
      <column-name>org_personnel_id</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>qualificationNameId</field-name>
      <column-name>qualification_name_id</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>familyNamePrefix</field-name>
      <column-name>family_name_prefix</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>familyName</field-name>
      <column-name>family_name</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>organizationId</field-name>
      <column-name>organization_id</column-name>
      </cmp-field>
      <query>
      <query-method>
      <method-name>ejbSelectGeneric</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      <method-param>java.lang.Object[]</method-param>
      </method-params>
      </query-method>
      <dynamic-ql/>
      </query>
      <query>
      <query-method>
      <method-name>ejbSelectCountGeneric</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      <method-param>java.lang.Object[]</method-param>
      </method-params>
      </query-method>
      <dynamic-ql/>
      </query>
      </entity>
      
      
      <entity>
      <ejb-name>QualificationNameEJB</ejb-name>
      <table-name>qualification_names</table-name>
      <cmp-field>
      <field-name>qualificationNameId</field-name>
      <column-name>qualification_name_id</column-name>
      </cmp-field>
      <query>
      <query-method>
      <method-name>ejbSelectGeneric</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      <method-param>java.lang.Object[]</method-param>
      </method-params>
      </query-method>
      <dynamic-ql/>
      </query>
      <query>
      <query-method>
      <method-name>ejbSelectCountGeneric</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      <method-param>java.lang.Object[]</method-param>
      </method-params>
      </query-method>
      <dynamic-ql/>
      </query>
      </entity>
      
      <ejb-relation>
      <ejb-relation-name>QualificationName - OrgPersonnel</ejb-relation-name>
      <ejb-relationship-role>
      <ejb-relationship-role-name>QualificationName-has-OrgPersonnels</ejb-relationship-role-name>
      <key-fields>
      <key-field>
      <field-name>qualificationNameId</field-name>
      <column-name>qualification_name_id</column-name>
      </key-field>
      </key-fields>
      </ejb-relationship-role>
      <ejb-relationship-role>
      <ejb-relationship-role-name>OrgPersonnel-is-QualificationName</ejb-relationship-role-name>
      <key-fields/>
      </ejb-relationship-role>
      </ejb-relation>