Hi ,
I had a problem to refresh my query after save or update operations, the query result is not changed after the corresponding record updated. It happen randomly, but very critical to the user using application developed with Hibernate. I use webwork as the framework for web development.


Hibernate version: 3.2

Mapping documents:
Bank statement file object

<hibernate-mapping package="ipcs.bs.domain" auto-import="true">
<class name="BsFile" table="BS_FILE" mutable="true" lazy="true" abstract="false">
<id name="bsFileId">
<column name="BS_FILE_ID" sql-type="NUMBER(19)" not-null="true" length="19"/>
<generator class="sequence">
<param name="sequence">BS_FILE_ID_SEQ</param>
</generator>
</id>
<property name="bsFileName" insert="true" update="true" optimistic-lock="true">
<column name="BS_FILE_NAME" sql-type="VARCHAR2(30)" length="30"/>
</property>
<many-to-one name="mbank" class="Mbank" update="true" insert="true">
<column name="BANK_ID" sql-type="NUMBER(19)" not-null="false" length="19"/>
</many-to-one>
<many-to-one name="bankAccount" class="BankAccount" update="true" insert="true">
<column name="ACCOUNT_ID" sql-type="NUMBER(19)" not-null="false" length="19"/>
</many-to-one>
<property name="currencyCode" insert="true" update="true" optimistic-lock="true">
<column name="CURRENCY_CODE" sql-type="VARCHAR2(3)" length="3"/>
</property>
<property name="startPeriod" insert="true" update="true" optimistic-lock="true">
<column name="START_PERIOD" sql-type="DATE"/>
</property>
<property name="endPeriod" insert="true" update="true" optimistic-lock="true">
<column name="END_PERIOD" sql-type="DATE"/>
</property>
<property name="startBalance" insert="true" update="true" optimistic-lock="true">
<column name="START_BALANCE" sql-type="NUMBER(19,2)" length="19" precision="2"/>
</property>
<property name="endBalance" insert="true" update="true" optimistic-lock="true">
<column name="END_BALANCE" sql-type="NUMBER(19,2)" length="19" precision="2"/>
</property>
<property name="totalDebit" insert="true" update="true" optimistic-lock="true">
<column name="TOTAL_DEBIT" sql-type="NUMBER(19,2)" length="19" precision="2"/>
</property>
<property name="totalCredit" insert="true" update="true" optimistic-lock="true">
<column name="TOTAL_CREDIT" sql-type="NUMBER(19,2)" length="19" precision="2"/>
</property>
<property name="loadMethod" insert="true" update="true" optimistic-lock="true">
<column name="LOAD_METHOD" sql-type="VARCHAR2(10)" length="10"/>
</property>
<property name="verificationStatus" insert="true" update="true" optimistic-lock="true">
<column name="VERIFICATION_STATUS" sql-type="VARCHAR2(15)" length="15"/>
</property>
<property name="postingStatus" insert="true" update="true" optimistic-lock="true">
<column name="POSTING_STATUS" sql-type="VARCHAR2(15)" length="15"/>
</property>
<property name="postingDate" insert="true" update="true" optimistic-lock="true">
<column name="POSTING_DATE" sql-type="DATE"/>
</property>
<property name="addby" insert="true" update="true" optimistic-lock="true">
<column name="ADDBY" sql-type="VARCHAR2(50)" length="50"/>
</property>
<property name="adddt" insert="true" update="true" optimistic-lock="true">
<column name="ADDDT" sql-type="DATE"/>
</property>
<property name="changeby" insert="true" update="true" optimistic-lock="true">
<column name="CHANGEBY" sql-type="VARCHAR2(50)" length="50"/>
</property>
<property name="changedt" insert="true" update="true" optimistic-lock="true">
<column name="CHANGEDT" sql-type="DATE"/>
</property>
<array name="bsRecord" optimistic-lock="true">
<key on-delete="noaction" unique="false">
<column name="BS_FILE_ID" sql-type="NUMBER(19)" not-null="false" length="19"/>
</key>
<list-index column="BS_RECORD_ID"/>
<one-to-many class="ipcs.bs.domain.BsRecord" not-found="ignore"/>
</array>
</class>
</hibernate-mapping>