ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Bennett" <mark.benn...@ncmail.net>
Subject RE: cacheModel still hitting database
Date Tue, 22 Feb 2005 13:44:59 GMT
Yup, that was it thanks.  Hey Steven, this may work for you too.

Mark

-----Original Message-----
From: Kris A. Jenkins [mailto:krisajenkins@yahoo.co.uk]
Sent: Monday, February 21, 2005 5:33 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: cacheModel still hitting database


Mark,

In your sql-map-config.xml, look at the 'settings'
attribute.  Do you have 'cacheModelsEnabled="true"'
set?

Kris


 --- Mark Bennett <mark.bennett@ncmail.net> 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>
>
>
>





___________________________________________________________
ALL-NEW Yahoo! Messenger - all new features - even more fun!
http://uk.messenger.yahoo.com



Mime
View raw message