I agree that the result is likely not cached in this case, but it is a bit
more subtle... Oracle REF_CURSORS read via OUT parameters are passed to
the main query OperationObserver, thus they are treated as regular query
results, and caching should follow all normal rules -
http://objectstyle.org/cayenne/userguide/fetch/result-caching.html ...
Andrus
> I think, because you are returning attributes as OUT parameters, not
> objects/entities, that they would be completely disconnected from the
> regular cache. In other words, getting an Integer returned from a
> stored procedure is completely uncached, while getting an Invoice
> returned from a normal Cayenne query/fault would be cached (if you have
> caching enabled).
>
> Short answer: NO, they aren't cached. Unless I'm wrong. :-)
>
> Thanks,
>
> /dev/mrg
>
>
> -----Original Message-----
> From: Pirola Davide [mailto:davide.pirol..tin.it]
> Sent: Thursday, February 10, 2005 5:21 AM
> To: cayenne-use..bjectstyle.org
> Subject: RE: Cache with StoredProcedure cursor parameter
>
>
> Hi Andrus,
> i know that i'am a nuisance :-)...
> but i need to know if cayenne's cache works with a cursors passed by
> stored procedure (out parameter). If the answer is yes, i need to know
> if exist a way to configure the cache parameters (size, timeout..).
>
> Thank's
> Davide
>
>
> -----Original Message-----
> From: Pirola Davide
> Sent: venerd́ 4 febbraio 2005 12.17
> To: cayenne-use..bjectstyle.org
> Subject: Cache with StoredProcedure cursor parameter
>
>
> Hi,
> i want to use cayenne's cache.
> I get my data via stored procedure out parameter (cursor).
> if i set:
>
> ProcedureQuery.setCachePolicy(GenericSelectQuery.LOCAL_CACHE);
>
> i can get the object from cached data?
> In a few words... getting data from out parameter can modify the
> behavior of cayenne's cache?
>
> Is possible to configure the cache parameters (size, timeout..)? Where
> (data map xml??)?
>
> Thank's
> Davide
This archive was generated by hypermail 2.0.0 : Thu Feb 10 2005 - 10:14:49 EST