Hi Guys, i am facing this net.sf.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or Unsaved-value mapping was incorrect) for sg.gov.moe.rm.edusave.persistence.WDByActBatch instance with identifier 7118-200704-W000003.

WDByActBatch extends persistent object class.

Could anyone highlight, what could be the actual reason of exception and under what circumstances this exception is thrown? what is the best way to solve this?

I am using the following hibernate mapping

<class name="sg.gov.moe.rm.edusave.persistence.EduBatch"
table="RM_EDU_BATCH">
<id name="batchID" column="BATCH_ID" type="java.lang.String">
<generator class="assigned" />
</id>


<version name="version" column="VERSION_NO"
type="java.lang.Short" />

<property name="batchTypeCode" column="BATCH_TYPE"
type="java.lang.Integer" />
<property name="batchStatusCode" column="STATUS_CODE"
type="java.lang.Integer" />
<property name="manual" column="MANUAL_FLAG" type="yes_no" />
<property name="deleteFlag" column="DELETE_IND" type="yes_no" />
<property name="createdBy" column="CREATED_BY" length="20"
type="java.lang.String" not-null="false" />
<property name="createdDate" column="CREATION_DATE"
type="java.util.Date" not-null="false" />
<property name="lastUpdatedBy" column="LAST_UPDATED_BY"
length="20" type="java.lang.String" not-null="false" />
<property name="lastUpdatedDate" column="LAST_UPDATED_DATE"
type="java.util.Date" not-null="false" />
<property name="schoolCPCode" column="SCHOOL_CODE" length="10"
type="java.lang.String" not-null="false" />
<joined-subclass
name="sg.gov.moe.rm.edusave.persistence.WDByActBatch"
table="RM_EDU_WD_BY_ACT_BATCH_HDR">
<key column="BATCH_ID" />


<component name="program"
class="sg.gov.moe.rm.edusave.persistence.Program">
<property name="enrichProgCat"
column="ENRICHMENT_PROG_CAT" />
<property name="progTitle" column="PROGRAMME_TITLE" />
<component name="act"
class="sg.gov.moe.rm.edusave.persistence.Activity">
<property name="actCode" column="activity_code" />
<property name="catCode" column="category_code" />

</component>
</component>
<set name="wdByActBatchDtls" cascade="delete">
<key column="BATCH_ID" />
<one-to-many
class="sg.gov.moe.rm.edusave.persistence.WDByActBatchDtl" />
</set>
<property name="createdBy" column="CREATED_BY" length="20"
type="java.lang.String" not-null="false" />
<property name="createdDate" column="CREATION_DATE"
type="java.util.Date" not-null="false" />
<property name="lastUpdatedBy" column="LAST_UPDATED_BY"
length="20" type="java.lang.String" not-null="false" />
<property name="lastUpdatedDate" column="LAST_UPDATED_DATE"
type="java.util.Date" not-null="false" />
<property name="versionN" column="VERSION_NO"
type="java.lang.Short" />
</joined-subclass>
</class>

Thank you,
Srinivas.

Hi chsri_111,

send your code where you are updating or deleting