Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: domain of garyjarrel@gmail.com designates
 74.125.83.43 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=P0M0SpgfMxL5xFhhxd65Y0zyVY6Ibj2VDvl55fCoYM7dBGIq2ZElBYPivD1hcPOL3b
         +E1IIrO8ZHNTOEgcWjfYqUKN3O1U6g+QcS+ZimfcV0ZIXf0vKu/jPB0Snnq0TC6Q+gWo
         NyK8/SltuNRqyWKiE0C/W/9vD2k3gsRgqQV8I=
MIME-Version: 1.0
In-Reply-To: <92583F17-2CBA-45B5-9C5A-5F4FE81F9255@objectstyle.org>
References: <AANLkTinNjW-ekdmmL7Vlxi39Qre04agg4LnbLXqs1HS4@mail.gmail.com>
	<92583F17-2CBA-45B5-9C5A-5F4FE81F9255@objectstyle.org>
Date: Fri, 28 May 2010 16:39:15 +1000
Message-ID: <AANLkTilajJMIHN2dwuXxygfqDIDmY-2gye8OcIB-mFWK@mail.gmail.com>
Subject: Re: More on caching
From: Gary Jarrel <garyjarrel@gmail.com>
To: user@cayenne.apache.org
Content-Type: text/plain; charset=ISO-8859-1

On Fri, May 28, 2010 at 4:28 PM, Andrus Adamchik <andrus@objectstyle.org> wrote:
>
> On May 28, 2010, at 9:20 AM, Gary Jarrel wrote:
>
>> I would expect that the the second query q2 would not execute any SQL
>> however the QueryLogger logs the second select statement.
>
> The second query has no cache group or cache strategy in your example, so it
> is not using caching.

Ahh I didn't realize that I had to specify the cache group for the
second query as well... I thought given that I was executing a query
with the same parameters it would have picked up the fact that one is
already cached without having to specify which cache group to look
into. Probably how I read the docs.

So does this mean that for query caching to work I have to specify the
cache group and cache strategy and that the modeler settings only
apply to Object cache?

>
>> Also the assert on the query cache size fails the it appears the size
>> is zero rather than 1 as I would have expected.
>
> is domain.getQueryCache().size() also returning zero?
>

No it seems that domain.getQueryCache().size() is returning 1

assertEquals(1, ((DataContext)
getDataContext()).getParentDataDomain().getQueryCache().size());
assertEquals(1, ((DataContext) getDataContext()).getQueryCache().size());

I've put these 2 lines into the test case and it fails on the second line.

Gary