[jboss-jira] [JBoss JIRA] Created: (JBAS-3465) updating entity bean not updates field in database
Yura Kravchuk (JIRA)
jira-events at jboss.com
Fri Aug 4 05:06:11 EDT 2006
updating entity bean not updates field in database
--------------------------------------------------
Key: JBAS-3465
URL: http://jira.jboss.com/jira/browse/JBAS-3465
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: CMP service, EJB2
Affects Versions: JBossAS-4.0.4.GA, JBossAS-4.0.3 SP1
Environment: Windows XP service pack 2 OEM
Reporter: Yura Kravchuk
Assigned To: Alexey Loubyansky
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.
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>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the jboss-jira
mailing list