cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Huttar" <lars_hut...@sil.org>
Subject esql xsp page caching?
Date Thu, 06 May 2004 21:55:30 GMT
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


Mime
View raw message