Did you delete the record using your application (ie. Using deleteSpecificVehicle) or through some other database client tool?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2008 10:07 PM To: [email protected] Subject: cache is not flush after delete Hi All, I am using ibatis.net DataMapper (recent build of 1.6.1 source) and have many mapping files where I use LRU cacheModel with no issues. There is one, however, where the object is not flushed when the record is deleted from the Database. If I try to load the object after is deleted I get back the old record (which should have been flushed). I have tried very hard to find any fault in the mapping but have not succeeded so far. An extract from my mapping: --------------------------------------------- <cacheModel id="SpecificVehicleCache" implementation="LRU" readOnly="false" serialize="true"> <flushInterval hours="1" /> <flushOnExecute statement="updateSpecificVehicle" /> <flushOnExecute statement="insertSpecificVehicle" /> <flushOnExecute statement="deleteSpecificVehicle" /> </cacheModel> .... <procedure id="getSpecificVehicleById" resultClass="SpecificVehicle" resultMap="SpecificVehicle" parameterMap="IdParameterMap" cacheModel="SpecificVehicleCache" > <![CDATA[IRM_spSpecificVehicleGetById]]> </procedure> <procedure id="deleteSpecificVehicle" parameterMap="SpecificVehicleIdAndCallerParameterMap"> <![CDATA[IRM_spSpecificVehicleDelete]]> </procedure> --------------------------------------------- Any ideas why this might be happening? Thanks in advance, Lazaro Pi
