Re: cacheModel still hitting database

[friendVU admin]

Try this as a test
<cacheModel id="mailmove_cache" type="MEMORY" >
   <flushInterval seconds= "360"/>
</cacheModel>
also build of ibatis?
.V

Mark Bennett wrote:

I'm trying to get the cacheModel working, but it keeps hitting the database.
This is just an example so please ignore the context.

I'm using iBatis-2 and this setup returns the data properly.  I get no
errors.  This is run through a web container and not a unit test so the
cache should persist.  The query object is an Integer so it should hash the
same each time.  However, whenever I cange the data in the databse, the
change shows up on the page.  Any advice?  Thanks.

Mark

 <cacheModel id="drugScreenCache" type="LRU" readOnly="true"
serialize="false">
   <flushInterval hours="12"/>
   <property name="cache-size" value="500"/>
 </cacheModel>

 <resultMap id="drugScreenListResult" class="drugScreen">
   <result property="id" column="ACTID"/>
   <result property="testDate" column="TESTDATE"/>
 </resultMap>

 <select id="getDrugScreenListByJuvenile"
                resultMap="drugScreenListResult"
                cacheModel="drugScreenCache">
   SELECT *
   FROM drugscreen
   WHERE rsrcid = #value#
   ORDER by TESTDATE DESC
 </select>