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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
