RE: Cache with StoredProcedure cursor parameter

From: Gentry, Michael \(Contractor\) ("Gentry,)
Date: Thu Feb 10 2005 - 10:03:57 EST

  • Next message: Laszlo Spoor: "[question] Tomcat 5.5 & JNDI DataSources"

    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:04:07 EST