<hibernate-mapping package="ca.empire.ehb.model" default-access="field" schema="dbo">

   <class name="ca.empire.ehb.model.claim.Claim" table="CLAIM">

      <id name="id" column="CLM_KY" type="ca.empire.ehb.model.type.LongType">
         <generator class="identity"/>
      </id>
      
      <version name="version" column="CLM_UPD_NU" access="org.hibernate.property.DirectPropertyAccessor" unsaved-value="negative" />

      <property name="accidentDate" column="CLM_ACD_DT" type="date" not-null="false" />
      <property name="accidentType" column="acd_typ_cd" type="string" not-null="false" />
      <property name="assigned" column="CLM_PAY_ASG_IN" type="boolean" not-null="true" />
      <property name="authReceived" column="CST_PLS_ATH_RCV_IN" type="boolean" not-null="true" />
      <property name="authSignatureReceived" column="CLM_ATH_SGN_PRS_IN" type="boolean" not-null="true" />

      <property name="ben" column="BEN_CD" type="ca.empire.ehb.model.type.StringType" length="5" not-null="true" />
      <property name="benType" column="BEN_TYP_CD" type="ca.empire.ehb.model.type.StringType" length="5" not-null="true" />

      <property name="caseId" column="CLM_CSE_ID_TX" type="string" length="50" not-null="false" />
      <property name="certSignatureReceived" column="CLM_CRT_SGN_IN" type="boolean" not-null="true" />
      <property name="claimId" column="CLM_ID" type="string" length="50" not-null="true" />
      <property name="cmp" column="CMP_CD" type="string" length="2" not-null="true" />

      <many-to-one name="claimType" class="ca.empire.ehb.model.code.ClaimType" not-null="true" lazy="false">
         <formula>'01'</formula>
          <column name="CLM_TYP_CD"/>   
          <formula>'E'</formula>   
      </many-to-one>

      <property name="designation" column="CLM_PYE_DSG_TX" type="string" length="50" not-null="false" />

      <property name="entryDate" column="CLM_ENT_DT" type="date" not-null="true" />

      <property name="groupRep" column="GRP_REP_ID" type="string" length="5" not-null="false" />

      <property name="HOAuthRecd" column="CLM_PLG_ADD_ATH_IN" type="boolean" not-null="true" />
      
      <property name="autoPayIHE" column="CLM_IHE_IN" type="boolean" not-null="true" />
      <property name="insuredPatientId" column="INS_PAT_KY" type="ca.empire.ehb.model.type.LongType" not-null="false" />

      <property name="manAdjProcessor" column="MAN_ADU_PRC_ID" type="ca.empire.ehb.model.type.StringType" length="8" not-null="false" />

      <property name="patientId" column="PAT_KY" type="ca.empire.ehb.model.type.LongType" not-null="false" />
      <property name="payeeEFT" column="CLM_PYE_EFT_IN" type="boolean" not-null="true" />
      <many-to-one name="providerOffice" class="ca.empire.ehb.model.ProviderOffice" column="PVD_OFF_KY" not-null="false" lazy="false" fetch="join"/>
      <property name="receivedDate" column="CLM_RCV_DT" type="date" not-null="true" />
      <property name="repAuth" column="CLM_PLG_REP_ATH_IN" type="boolean" not-null="true" />
      <property name="rushPaymentUserId" column="RSH_PRC_USR_ID" type="string" length="8" not-null="false" />

      <!--property name="status" column="CLM_STA_CD" type="string" length="2" not-null="false" /-->
      <many-to-one name="status" class="ca.empire.ehb.model.code.ClaimStatus" not-null="true" lazy="false">
         <formula>'01'</formula>
          <column name="CLM_STA_CD"/>   
          <formula>'E'</formula>   
      </many-to-one>
      
      <!--property name="savedStatus" column="CLM_STA_CD"  not-null="false" generated="always" update="false" insert="false" /-->
      <many-to-one name="savedStatus" class="ca.empire.ehb.model.code.ClaimStatus" not-null="false" lazy="false" insert="false" update="false">
         <formula>'01'</formula>
          <column name="CLM_STA_CD"/>   
          <formula>'E'</formula>   
      </many-to-one>
      
      <property name="scheduledPaymentDate" column="CLM_SCH_PAY_DT" type="date" not-null="false" />

      <property name="travelFromDate" column="CLM_TRV_FRM_DT" type="date" not-null="false" />
      <property name="travelToDate" column="CLM_TRV_TO_DT" type="date" not-null="false" />


      <property name="xryReceived" column="CLM_XRY_RCV_IN" type="boolean" not-null="true" />
      <property name="xryReturn" column="CLM_XRY_RTR_IN" type="boolean" not-null="true" />
      
      <component name="overridePayee" class="OverridePayee" lazy="false" insert="true" update="true">
         <property name="careOf" column="CLM_PYE_ATN_NM" type="ca.empire.ehb.model.type.StringType" length="50" not-null="false" />
         <property name="city" column="CLM_PYE_CTY_AD" type="string" length="50" not-null="false" />
         <property name="country" column="CLM_PYE_CNY_AD" type="string" length="50" not-null="false" />
         <property name="title" column="CLM_PYE_TTL_TX" type="string" length="50" not-null="false" />
         <property name="givenName" column="CLM_PYE_GVN_NM" type="string" length="50" not-null="false" />
         <property name="lastName" column="CLM_PYE_LST_NM" type="ca.empire.ehb.model.type.StringType" length="50" not-null="false" />
         <property name="postCode" column="CLM_PYE_POS_CD" type="string" length="10" not-null="false" />
         <property name="province" column="CLM_PYE_PRV_CD" type="string" length="2" not-null="false" />
         <property name="street" column="CLM_PYE_STR_AD" type="string" length="50" not-null="false" />
         <property name="unit" column="CLM_PYE_UNT_APT_AD" type="string" length="50" not-null="false" />
      </component>
      <component name="bank" class="ca.empire.ehb.model.claim.Bank" lazy="false" insert="true" update="true">
         <property name="transit" column="clm_pye_bnk_trn_nu" type="ca.empire.ehb.model.type.StringType" not-null="false"/>
         <property name="institution" column="clm_pye_bnk_ist_cd" type="ca.empire.ehb.model.type.StringType" not-null="false"/>
         <property name="account" column="clm_pye_bnk_acc_nu" type="ca.empire.ehb.model.type.StringType" not-null="false"/>
      </component>
      <bag name="claimDetails" inverse="true" cascade="all-delete-orphan" lazy="true" order-by="CLM_PRC_SRV_DT,ENT_PRC_CD">
         <key column="CLM_KY" not-null="true" />
         <one-to-many entity-name="ClaimDetail" />
      </bag>
      <bag name="adjudicationClaimOutputList" inverse="true" cascade="all-delete-orphan" lazy="false" fetch="join">
         <key column="clm_out_rlt_ky" not-null="true" />
         <one-to-many  entity-name="ca.empire.ehb.model.claim.ClaimAdjudicationOutput" />
      </bag>
      <one-to-one name="claimBenefit" property-ref="claim" fetch="join" cascade="all"/>
      <many-to-one name="insuredCertificate" column="INS_CRT_KY" not-null="false" class="Certificate" />
      <bag name="claimStatusHistoryList" inverse="true" cascade="all-delete-orphan" lazy="true" order-by="clm_sta_chg_dt desc">
         <key column="clm_ky" not-null="true"/>
         <one-to-many entity-name="ca.empire.ehb.model.claim.ClaimStatusHistory"/>
      </bag>
      <any name="patient" id-type="long" meta-type="ca.empire.ehb.model.type.UpperTrimStringType">
          <meta-value value="CERTIFICATE" class="PersonCertificate"/>
          <meta-value value="DEPENDANT" class="PersonDependant"/>
          <column name="pat_rlt_nm"/>
          <column name="pat_rlt_ky"/>
      </any>
                  
      
   </class>

</hibernate-mapping>

<hibernate-mapping package="ca.empire.ehb.model.claim" default-access="field" schema="dbo">

   <class name="Adjudication" table="claim_output" discriminator-value="">

      <id name="id" column="clm_out_ky" type="ca.empire.ehb.model.type.LongType">
         <generator class="identity"/>
      </id>
      <discriminator column="clm_out_rlt_nm" type="string" insert="true" force="true"/>

        <property name="adjudicationRuleText" column="adu_rul_out_tx" type="string" length="50" not-null="false" />
        <property name="overrideUserID" column="adu_ovr_usr_id" type="string" length="8" not-null="false" />
      <property name="processed" column="adu_rul_pas_in" type="boolean" not-null="true" />
      <property name="adjudicationOutputParameter" column="adu_out_pam_tx" type="string"/>
       
        <many-to-one name="adjudicationOutput" class="ca.empire.ehb.model.code.AdjudicationOutput" not-null="true" lazy="false">
         <formula>'01'</formula>
          <column name="adu_out_cd"/>   
          <formula>'E'</formula>   
      </many-to-one>
      
       <subclass name="ClaimAdjudicationOutput" discriminator-value="claim">
          <many-to-one name="claim" class="ca.empire.ehb.model.claim.Claim" column="clm_out_rlt_ky" not-null="true" />
       </subclass>
      
       <subclass name="ClaimDetailAdjudicationOutput" discriminator-value="claim_details">
          <many-to-one name="claimDetail" entity-name="ClaimDetail" column="clm_out_rlt_ky" not-null="true"  />
       </subclass>
   </class>

</hibernate-mapping>

<hibernate-mapping package="ca.empire.ehb.model.claim" default-access="field" schema="dbo">
   <class name="ClaimBenefit" table="CLAIM_BENEFIT">

      <id name="id" column="CLM_BEN_KY" type="ca.empire.ehb.model.type.LongType">
         <generator class="identity"/>
      </id>
      <property name="disabilityDate" column="clm_dsl_dt" type="date" not-null="true"/>
       <property name="savedDisabilityDate" column="clm_dsl_dt" not-null="true" insert="false" update="false"/>
       <property name="accrueFromDate" column="acr_frm_dt" type="date" not-null="false"/>
       <property name="savedAccrueFromDate" column="acr_frm_dt" type="date" not-null="false" insert="false" update="false"/>
       <property name="approvedToDate" column="clm_apv_to_dt" type="date" not-null="false"/>
       <property name="savedApprovedToDate" column="clm_apv_to_dt" type="date" not-null="false" insert="false" update="false"/>
       <property name="halfDay" column="hlf_day_in" type="boolean" not-null="true" />
       <property name="paidToDate" column="clm_pd_to_dt" type="date" not-null="false"/>
       <property name="closeReasonCode" column="clo_rsn_cd" type="string" not-null="false" />
       <property name="followUpCode" column="fll_cd" type="string" not-null="false"/>
       <property name="followUpDate" column="fll_dt" type="date" not-null="false"/>
       <property name="sin" column="crt_sin" type="ca.empire.ehb.model.type.StringType" not-null="false"/>
       <property name="assessor" column="asr_usr_tx" type="string" not-null="false"/>
       <property name="rehab" column="reh_coo_usr_id" type="ca.empire.ehb.model.type.StringType" not-null="false"/>
       <property name="addressChoice" column="ad_chc_cd" type="string" not-null="false"/>
       <property name="employeeDisabilityDate" column="emp_dsl_dt" type="date" not-null="false"/>
       <property name="employeeLastWorkDate" column="emp_ldw_dt" type="date" not-null="false"/>
       <property name="employeeExpectedReturnToWorkDate" column="emp_rtw_dt" type="date" not-null="false"/>
       <property name="employerLastWorkDate" column="emr_ldw_dt" type="date" not-null="false"/>
       <property name="employerExpectedReturnToWorkDate" column="emr_rtw_dt" type="date" not-null="false"/>
       <property name="wcbcsst" column="wcb_clm_in" type="boolean" not-null="true"/>
       <property name="occupation" column="occ_tx" type="string" not-null="false"/>
       <property name="workRelated" column="wrk_rlt_dsl_in" type="boolean" not-null="true"/>
       <property name="daySurgeryDate" type="date" column="day_srg_dt" not-null="false"/>
       <property name="firstPhysicianVisitDate" type="date" column="phy_fst_vst_dt" not-null="false"/>
       <property name="lastPhysicianVisitDate" type="date" column="phy_lst_vst_dt" not-null="false"/>
       <property name="hospitalAdminDate" type="date" column="hsp_adm_dt" not-null="false"/>
       <property name="hospitalDischargeDate" type="date" column="hsp_dch_dt" not-null="false"/>
       <property name="diagnosis" type="string" column="phy_dia_tx" not-null="false"/>
       <property name="physicianRemarks" type="string" column="phy_not_tx" not-null="false"/>
       <property name="physicianDisabilityDate" type="date" column="phy_dsl_dt" not-null="false"/>
       <property name="physicianReturnToWorkDate" type="date" column="phy_rtw_dt" not-null="false"/>
       <property name="grossBenefitAmount" type="big_decimal" column="grs_ben_am" not-null="false"/>
       <!-- property name="netBenefitAmount" type="big_decimal" column="" not-null="false"/ -->
       <property name="adjAmount" type="big_decimal" column="adj_ben_am" not-null="false"/>
       <property name="savedAdjAmount" type="big_decimal" column="adj_ben_am" not-null="false" insert="false" update="false"/>
       <property name="overrideAuth" type="ca.empire.ehb.model.type.StringType" column="amt_ovr_usr_id" not-null="false"/>
       <property name="authorizationCode" column="ath_cd" type="string" not-null="false"/>
       <property name="federalTaxPercentage" type="big_decimal" column="fed_tax_pc" not-null="false"/>
       <property name="federalTaxAmount" type="big_decimal" column="fed_tax_am" not-null="false"/>
       <property name="wcbcsstDeductAmount" type="big_decimal" column="wcb_pay_ded_am" not-null="false"/>
       <property name="cppqppDeductAmount" type="big_decimal" column="cpp_pay_ded_am" not-null="false"/>
       <property name="otherIncomeDeductAmount" type="big_decimal" column="oth_pay_ded_am" not-null="false"/>
       <property name="totalPaid" type="big_decimal" column="tot_pd_am" not-null="false"/>
       <property name="months" type="integer" column="tot_mth_pd_nu" not-null="false"/>
       <property name="days" type="big_decimal" column="tot_day_pd_nu" not-null="false"/>
       <property name="employerContributionPercentage" type="big_decimal" column="emr_cnr_pc" not-null="false"/>
       <property name="employerContributionFlatAmount" type="big_decimal" column="emr_cnr_flt_am" not-null="false"/>
       <property name="taxable" type="boolean" column="tax_in" not-null="true"/>
       <property name="ownOccPeriodNumber" type="integer" column="own_occ_prd_nu" not-null="false"/>
       <property name="ownOccPeriodUnit" type="string" column="own_occ_prd_cd" not-null="false"/>
       <property name="firstDayHospitalCode" type="string" column="fst_day_hsp_cd" not-null="false"/>
       <property name="classCode" type="string" column="cls_cd" not-null="false"/>
       <property name="incomeInegrationCode" type="string" column="inc_int_cd" not-null="false"/>
       <property name="payBasisNumber" type="integer" column="pay_bss_prd_nu" not-null="false"/>
       <property name="payBasisUnit" type="ca.empire.ehb.model.type.StringType" column="pay_bss_prd_cd" not-null="false"/>
       <property name="terminationAgeNumber" type="integer" column="trm_age_nu" not-null="false"/>
       <property name="colaMonth" type="ca.empire.ehb.model.type.StringType" column="cola_mth_tx" not-null="false"/>
       <property name="colaPercentage" type="big_decimal" column="cola_pc" not-null="false"/>
       <property name="flatAmount" type="big_decimal" column="flt_am" not-null="false"/>
       <property name="salaryPercentage" type="big_decimal" column="sal_pc" not-null="false"/>
       <property name="schedule" type="string" column="grd_sch_cd" not-null="false"/>
       <property name="maxAmount" type="big_decimal" column="max_grs_ben_am" not-null="false"/>
       <property name="nemAllowed" type="big_decimal" column="nem_all_am" not-null="false"/>
       <property name="accidentElimNumber" type="integer" column="acd_elm_prd_nu" not-null="false"/>
       <property name="accidentElimUnit" type="ca.empire.ehb.model.type.StringType" column="acd_elm_prd_cd" not-null="false"/>
       <property name="sickElimNumber" type="integer" column="sck_elm_prd_nu" not-null="false"/>
       <property name="sickElimUnit" type="ca.empire.ehb.model.type.StringType" column="sck_elm_prd_cd" not-null="false"/>
       <property name="accidentBenefitNumber" type="integer" column="acd_ben_prd_nu" not-null="false"/>
       <property name="accidentBenefitUnit" type="ca.empire.ehb.model.type.StringType" column="acd_ben_prd_cd" not-null="false"/>
       <property name="sickBenefitNumber" type="integer" column="sck_ben_prd_nu" not-null="false"/>
       <property name="sickBenefitUnit" type="ca.empire.ehb.model.type.StringType" column="sck_ben_prd_cd" not-null="false"/>
       <property name="limitPercentage" type="big_decimal" column="lmt_pc" not-null="false"/>
       <property name="limitCode" type="string" column="lmt_cd" not-null="false"/>
       <property name="carveOutCode" type="string" column="crv_out_cd" not-null="false"/>
       <property name="ownOccIndicator" type="boolean" column="own_occ_in" not-null="true"/>
       <!-- property name="surviverBenefitCode" type="" not-null="false"/ -->
       <property name="surviveBenefitNumber" type="integer" column="sur_ben_prd_nu" not-null="false"/>
       <property name="reinsurer" type="string" column="rnr_cd" not-null="false"/>
       <property name="reinsurerBasic" type="string" column="rnr_bss_cd" not-null="false"/>
       <property name="reserveCalCode" type="string" column="rsv_cal_cd" not-null="false"/>
       <many-to-one name="claim" class="ca.empire.ehb.model.claim.Claim" unique="true" column="CLM_KY" lazy="false" not-null="true" />
   </class>
</hibernate-mapping>

public void deleteClaim(Claim claim)
{
    delete(claim);
}

[26/03/08 13:00:27:445 EDT] 472d472d SystemOut     O DEBUG DeleteClaimAction:55 - Calling action: /ehbweb/deleteClaim.do
[26/03/08 13:00:27:445 EDT] 472d472d SystemOut     O DEBUG EHBCommonTaskHandler:64 - retries = 0
[26/03/08 13:00:27:477 EDT] 472d472d SystemOut     O Hibernate: update dbo.CLAIM set CLM_UPD_NU=?, CLM_ACD_DT=?, acd_typ_cd=?, CLM_PAY_ASG_IN=?, CST_PLS_ATH_RCV_IN=?, CLM_ATH_SGN_PRS_IN=?, BEN_CD=?, BEN_TYP_CD=?, CLM_CSE_ID_TX=?, CLM_CRT_SGN_IN=?, CLM_ID=?, CMP_CD=?, CLM_TYP_CD=?, CLM_PYE_DSG_TX=?, CLM_ENT_DT=?, GRP_REP_ID=?, CLM_PLG_ADD_ATH_IN=?, CLM_IHE_IN=?, INS_PAT_KY=?, MAN_ADU_PRC_ID=?, PAT_KY=?, CLM_PYE_EFT_IN=?, PVD_OFF_KY=?, CLM_RCV_DT=?, CLM_PLG_REP_ATH_IN=?, RSH_PRC_USR_ID=?, CLM_STA_CD=?, CLM_SCH_PAY_DT=?, CLM_TRV_FRM_DT=?, CLM_TRV_TO_DT=?, CLM_XRY_RCV_IN=?, CLM_XRY_RTR_IN=?, CLM_PYE_ATN_NM=?, CLM_PYE_CTY_AD=?, CLM_PYE_CNY_AD=?, CLM_PYE_TTL_TX=?, CLM_PYE_GVN_NM=?, CLM_PYE_LST_NM=?, CLM_PYE_POS_CD=?, CLM_PYE_PRV_CD=?, CLM_PYE_STR_AD=?, CLM_PYE_UNT_APT_AD=?, clm_pye_bnk_trn_nu=?, clm_pye_bnk_ist_cd=?, clm_pye_bnk_acc_nu=?, INS_CRT_KY=?, pat_rlt_nm=?, pat_rlt_ky=? where CLM_KY=? and CLM_UPD_NU=?
[26/03/08 13:00:27:492 EDT] 472d472d SystemOut     O Hibernate: delete from dbo.claim_output where clm_out_ky=?
[26/03/08 13:00:27:508 EDT] 472d472d SystemOut     O Hibernate: delete from dbo.claim_output where clm_out_ky=?
[26/03/08 13:00:27:508 EDT] 472d472d SystemOut     O Hibernate: delete from dbo.claim_output where clm_out_ky=?
[26/03/08 13:00:27:508 EDT] 472d472d SystemOut     O Hibernate: delete from dbo.claim_output where clm_out_ky=?
[26/03/08 13:00:27:508 EDT] 472d472d SystemOut     O Hibernate: delete from dbo.claim_output where clm_out_ky=?
[26/03/08 13:00:27:539 EDT] 472d472d SystemOut     O ERROR AbstractBatcher:61 - Exception executing batch:
org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 1 actual row count: 0 expected: 1
   at org.hibernate.jdbc.BatchingBatcher.checkRowCount(BatchingBatcher.java:93)
   at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:79)
   at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
   at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91)
   at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
   at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
   at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2271)
   at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2440)
   at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:65)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:145)
   at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
   at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
   at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
   at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356)
   at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59)
   at com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:146)
   at com.ibm.ws.Transaction.JTA.TransactionImpl.internalPrepare(TransactionImpl.java:1254)
   at com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:991)
   at com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:150)
   at com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:177)
   at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:735)
   at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:168)
   at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:570)
   at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3068)
   at ca.empire.ehb.domain.facade.ejb.EJSLocalStatelessClaimServiceFacade_a999737c.deleteClaim(EJSLocalStatelessClaimServiceFacade_a999737c.java:502)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
   at java.lang.reflect.Method.invoke(Method.java:391)
   at ca.empire.ehb.web.proxy.EHBCommonTaskHandler.delegateCall(EHBCommonTaskHandler.java:95)
   at ca.empire.ehb.web.proxy.EHBCommonTaskHandler.invoke(EHBCommonTaskHandler.java:69)
   at $Proxy0.deleteClaim(Unknown Source)
   at ca.empire.ehb.web.action.DeleteClaimAction.doExecute(DeleteClaimAction.java:55)
   at ca.empire.ehb.web.action.BaseAction.execute(BaseAction.java:76)
   at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
   at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
   at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
   at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
   at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
   at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
   at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
   at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
   at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
   at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
   at ca.empire.ehb.web.security.AccessControllerFilter.doFilter(AccessControllerFilter.java:47)
   at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
   at ca.empire.ehb.web.security.PostLoginFilter.doFilter(PostLoginFilter.java:120)
   at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
   at ca.empire.ehb.web.security.SessionCheckerFilter.doFilter(SessionCheckerFilter.java:68)
   at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
   at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1009)
   at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:529)
   at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:208)
   at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
   at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:321)
   at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
   at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:246)
   at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
   at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
   at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)
   at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448)
   at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:937)
[26/03/08 13:00:27:539 EDT] 472d472d SystemOut     O ERROR AbstractFlushingEventListener:299 - Could not synchronize database state with session
org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 1 actual row count: 0 expected: 1
   at org.hibernate.jdbc.BatchingBatcher.checkRowCount(BatchingBatcher.java:93)
   at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:79)
   at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
   at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91)
   at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
   at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
   at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2271)
   at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2440)
   at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:65)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:145)
   at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
   at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
   at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
   at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356)
   at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59)
   at com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:146)
   at com.ibm.ws.Transaction.JTA.TransactionImpl.internalPrepare(TransactionImpl.java:1254)
   at com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:991)
   at com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:150)
   at com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:177)
   at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:735)
   at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:168)
   at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:570)
   at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3068)
   at ca.empire.ehb.domain.facade.ejb.EJSLocalStatelessClaimServiceFacade_a999737c.deleteClaim(EJSLocalStatelessClaimServiceFacade_a999737c.java:502)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
   at java.lang.reflect.Method.invoke(Method.java:391)
   at ca.empire.ehb.web.proxy.EHBCommonTaskHandler.delegateCall(EHBCommonTaskHandler.java:95)
   at ca.empire.ehb.web.proxy.EHBCommonTaskHandler.invoke(EHBCommonTaskHandler.java:69)
   at $Proxy0.deleteClaim(Unknown Source)
   at ca.empire.ehb.web.action.DeleteClaimAction.doExecute(DeleteClaimAction.java:55)
   at ca.empire.ehb.web.action.BaseAction.execute(BaseAction.java:76)
   at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
   at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
   at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
   at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
   at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
   at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
   at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
   at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
   at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
   at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
   at ca.empire.ehb.web.security.AccessControllerFilter.doFilter(AccessControllerFilter.java:47)
   at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
   at ca.empire.ehb.web.security.PostLoginFilter.doFilter(PostLoginFilter.java:120)
   at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
   at ca.empire.ehb.web.security.SessionCheckerFilter.doFilter(SessionCheckerFilter.java:68)
   at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
   at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1009)
   at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:529)
   at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:208)
   at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
   at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:321)
   at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
   at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:246)
   at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
   at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
   at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)
   at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448)
   at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:937)
[26/03/08 13:00:27:539 EDT] 472d472d RegisteredSyn E WTRN0074E: Exception caught from before_completion synchronization operation: org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 1 actual row count: 0 expected: 1
   at org.hibernate.jdbc.BatchingBatcher.checkRowCount(BatchingBatcher.java:93)
   at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:79)
   at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
   at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91)
   at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
   at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
   at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2271)
   at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2440)
   at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:65)
   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:145)
   at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
   at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
   at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
   at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356)
   at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59)
   at com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:146)
   at com.ibm.ws.Transaction.JTA.TransactionImpl.internalPrepare(TransactionImpl.java:1254)
   at com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:991)
   at com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:150)
   at com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:177)
   at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:735)
   at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:168)
   at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:570)
   at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3068)
   at ca.empire.ehb.domain.facade.ejb.EJSLocalStatelessClaimServiceFacade_a999737c.deleteClaim(EJSLocalStatelessClaimServiceFacade_a999737c.java:502)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
   at java.lang.reflect.Method.invoke(Method.java:391)
   at ca.empire.ehb.web.proxy.EHBCommonTaskHandler.delegateCall(EHBCommonTaskHandler.java:95)
   at ca.empire.ehb.web.proxy.EHBCommonTaskHandler.invoke(EHBCommonTaskHandler.java:69)
   at $Proxy0.deleteClaim(Unknown Source)
   at ca.empire.ehb.web.action.DeleteClaimAction.doExecute(DeleteClaimAction.java:55)
   at ca.empire.ehb.web.action.BaseAction.execute(BaseAction.java:76)
   at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
   at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
   at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
   at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
   at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
   at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
   at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
   at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
   at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
   at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
   at ca.empire.ehb.web.security.AccessControllerFilter.doFilter(AccessControllerFilter.java:47)
   at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
   at ca.empire.ehb.web.security.PostLoginFilter.doFilter(PostLoginFilter.java:120)
   at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
   at ca.empire.ehb.web.security.SessionCheckerFilter.doFilter(SessionCheckerFilter.java:68)
   at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
   at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
   at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1009)
   at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:529)
   at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:208)
   at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
   at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:321)
   at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
   at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:246)
   at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
   at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
   at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)
   at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448)
   at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:937)

- WebSphere 5.1.2
- JDBCProvider implementationClassName="com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource"
- connectionProperties = "SELECT_OPENS_CURSOR=true;HOSTPROC=100"
<connectionPool xmi:id="ConnectionPool_1172689021796" connectionTimeout="1800" maxConnections="10" minConnections="1" reapTime="180" unusedTimeout="1800" agedTimeout="0" purgePolicy="EntirePool"/>