cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yves Vindevogel <yves.vindevo...@implements.be>
Subject Re: esql xsp page caching?
Date Fri, 07 May 2004 09:06:10 GMT
Hi Lars,

I bumped into the same problem too, but, I found out that it was not 
Cocoon who was caching.
My client had a Mickeysoft Isa Server as proxy and even with the meta 
tags like "pragma no cache", Isa kept caching the URL.
I found out that it was based on the URL, so when I gave another URL 
with a dummy parameter in it, it did not cache.
What I eventually did, was adding the session-id to the URL, so at 
least between two sessions, the problem was fixed.

On 06 May 2004, at 23:55, Lars Huttar wrote:

> Hi all,
>
> I have the following simple XSP page:
>
> <xsp:page language="java"
>     xmlns:xsp="http://apache.org/xsp"
>     xmlns:xsp-request="http://apache.org/xsp/request/2.0"
>     xmlns:esql="http://apache.org/cocoon/SQL/v2"
>     xmlns:sil="http://www.sil.org/namespace/cocoon-sql-logicsheet">
>
>   <footer>
>     <code><xsp-request:get-parameter name="code"/></code>
>
>     <sil:query connection="ethnolog">
>             SELECT to_char(sysdate, 'Dy dd-Mon-yyyy') AS Current_Date,
>                          to_char(sysdate, 'HH:MM AM') AS Current_Time
>              FROM Dual
>     </sil:query>
>
>   </footer>
> </xsp:page>
>
>
> It works as expected, except that once you start running it,
> it continues to return the same answer for the Current_Time,
> even 1/2 hour later!
> Anybody know if this is an XSP/ESQL caching issue, or perhaps
> an Oracle db issue?
>
> I'm confused...
>
> If needed, here's the logicsheet template that expands the <sil:query>
> element:
>
>
>
>   <xsl:template match="sil:query">
>     <!-- get 'connection' parameter -->
>     <xsl:variable name="connection">
>       <xsl:call-template name="get-param">
>         <xsl:with-param name="name" select="'connection'" />
>       </xsl:call-template>
>     </xsl:variable>
>     <!-- get 'row-element' parameter -->
>     <xsl:variable name="row-element">
>       <xsl:call-template name="get-param">
>         <xsl:with-param name="name" select="'row-element'" />
>       </xsl:call-template>
>     </xsl:variable>
>
>     <xsl:variable name="execute-query">
>       <esql:execute-query>
>         <esql:query>
>           <xsl:apply-templates select="node()|@*" />
>         </esql:query>
>         <esql:results>
>           <esql:row-results>
>             <xsl:choose>
>               <xsl:when test="string($row-element)">
>                 <xsl:element name="{$row-element}">
>                   <esql:get-columns />
>                 </xsl:element>
>               </xsl:when>
>               <xsl:otherwise>
>                 <esql:get-columns />
>               </xsl:otherwise>
>             </xsl:choose>
>           </esql:row-results>
>         </esql:results>
>       </esql:execute-query>
>     </xsl:variable>
>
>     <xsl:choose>
>       <xsl:when test="string($connection)">
>         <esql:connection>
>           <esql:pool><xsl:value-of select="$connection" /></esql:pool>
>           <xsl:copy-of select="$execute-query" />
>         </esql:connection>
>       </xsl:when>
>       <xsl:otherwise>
>         <xsl:copy-of select="$execute-query" />
>       </xsl:otherwise>
>     </xsl:choose>
>
>   </xsl:template>
>
>
> Thanks,
> Lars
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message