cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From AK...@burntsand.com
Subject Help with ESQL
Date Wed, 07 Feb 2001 23:05:08 GMT
Hi Donald,
 
After going through the mailing list archive, your name came up as a
possible authority on this - hope
you can help.
 
I've installed Coccon 1.8.2 on Weblogic 6.0.
 
The installation went fine - however, when I tried out the esql.xml example
in the SQL directory (by making modifications to
connect to our database ), I got the following error message show below.
Can you throw some light on this.
 
Thanks in advance
 
The esql.xml file is
 
<?xml version="1.0"?>
 
<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<?xml-stylesheet type="text/xsl" href="esql.xsl"?>
 
<xsp:page
  xmlns:xsp="  <http://www.apache.org/1999/XSP/Core>
http://www.apache.org/1999/XSP/Core"
  xmlns:esql="  <http://apache.org/cocoon/SQL/v2>
http://apache.org/cocoon/SQL/v2"
>
 
<page>
<esql:connection>
  <esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
  <esql:dburl>jdbc:oracle:thin://localhost/MEOH</esql:dburl>
  <esql:username>ewins</esql:username>
  <esql:password>ewins</esql:password>
  <esql:execute-query>
    <esql:query>select document_type_id,document_type_desc from
document_type</esql:query>
    <esql:results>
      <header>header info</header>
      <esql:row-results>
        <department>
          <id><esql:get-string column="document_type_id"/></id>
          <name><esql:get-string column="document_type_desc"/></name>
        </department>
      </esql:row-results>
      <footer>footer info</footer>
    </esql:results>
  </esql:execute-query>
</esql:connection>
 
</page>
 
</xsp:page>
 
and the corresponding xsl file is :
 
<?xml version="1.0"?>
 
<xsl:stylesheet
  xmlns:xsl="  <http://www.w3.org/1999/XSL/Transform>
http://www.w3.org/1999/XSL/Transform"
  version="1.0"
>
 
<xsl:template match="/page">
  <html>
    <head>
      <title>Apache Cocoon - esql sample page</title>
    </head>
    <body>
      <p>
        <xsl:value-of select="header"/>
      </p>
      <table border="1">
        <xsl:for-each select="department">
          <tr>
            <td>
              <xsl:value-of select="id"/>
            </td>
            <td>
              <xsl:value-of select="name"/>
            </td>
          </tr>
        </xsl:for-each>
      </table>
      <p>
        <xsl:value-of select="footer"/>
      </p>
    </body>
  </html>
</xsl:template>
 
</xsl:stylesheet>
 





Cocoon 1.8.2






Error found handling the request.


org.apache.xalan.xslt.XSLProcessorException: pattern = '$environment =
'cocoon1''

VariableReference given for variable out of context or without definition!
Name = environment

	at
org.apache.xalan.xslt.XSLTEngineImpl.error(XSLTEngineImpl.java:1710)

	at
org.apache.xalan.xslt.XSLTEngineImpl.error(XSLTEngineImpl.java:1674)

	at
org.apache.xalan.xslt.XSLTEngineImpl.process(XSLTEngineImpl.java:703)

	at
org.apache.cocoon.transformer.XalanTransformer.transform(XalanTransformer.ja
va:107)

	at
org.apache.cocoon.processor.xsp.XSPLogicsheet.apply(XSPLogicsheet.java:102)

	at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:445)

	at org.apache.cocoon.Engine.handle(Engine.java:384)

	at org.apache.cocoon.Cocoon.service(Cocoon.java:183)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:208)

	at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:1127)

	at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:1529)

	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)

	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

---------

org.apache.xalan.xslt.XSLProcessorException: pattern = '$environment =
'cocoon1''

VariableReference given for variable out of context or without definition!
Name = environment

	at
org.apache.xalan.xslt.StylesheetRoot.process(StylesheetRoot.java:437)

	at
org.apache.xalan.xslt.XSLTEngineImpl.process(XSLTEngineImpl.java:679)

	at
org.apache.cocoon.transformer.XalanTransformer.transform(XalanTransformer.ja
va:107)

	at
org.apache.cocoon.processor.xsp.XSPLogicsheet.apply(XSPLogicsheet.java:102)

	at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:445)

	at org.apache.cocoon.Engine.handle(Engine.java:384)

	at org.apache.cocoon.Cocoon.service(Cocoon.java:183)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:208)

	at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:1127)

	at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:1529)

	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)

	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

---------

org.apache.xalan.xslt.XSLProcessorException: pattern = '$environment =
'cocoon1''

VariableReference given for variable out of context or without definition!
Name = environment

	at
org.apache.xalan.xslt.Stylesheet.pushTopLevelVariables(Stylesheet.java:986)

	at
org.apache.xalan.xslt.XSLTEngineImpl.resolveTopLevelParams(XSLTEngineImpl.ja
va:3130)

	at
org.apache.xalan.xslt.StylesheetRoot.process(StylesheetRoot.java:433)

	at
org.apache.xalan.xslt.XSLTEngineImpl.process(XSLTEngineImpl.java:679)

	at
org.apache.cocoon.transformer.XalanTransformer.transform(XalanTransformer.ja
va:107)

	at
org.apache.cocoon.processor.xsp.XSPLogicsheet.apply(XSPLogicsheet.java:102)

	at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:445)

	at org.apache.cocoon.Engine.handle(Engine.java:384)

	at org.apache.cocoon.Cocoon.service(Cocoon.java:183)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:208)

	at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:1127)

	at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:1529)

	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)

	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

---------

org.apache.xalan.xpath.XPathException: pattern = '$environment = 'cocoon1''

VariableReference given for variable out of context or without definition!
Name = environment

	at org.apache.xalan.xpath.XPath.error(XPath.java:1562)

	at org.apache.xalan.xpath.XPath.variable(XPath.java:898)

	at org.apache.xalan.xpath.XPath.execute(XPath.java:1375)

	at org.apache.xalan.xpath.XPath.equals(XPath.java:586)

	at org.apache.xalan.xpath.XPath.execute(XPath.java:1358)

	at org.apache.xalan.xpath.XPath.execute(XPath.java:1354)

	at org.apache.xalan.xpath.XPath.execute(XPath.java:311)

	at org.apache.xalan.xslt.ElemChoose.execute(ElemChoose.java:118)

	at
org.apache.xalan.xslt.ElemTemplateElement.executeChildren(ElemTemplateElemen
t.java:661)

	at
org.apache.xalan.xslt.XSLTEngineImpl.createResultTreeFrag(XSLTEngineImpl.jav
a:2179)

	at
org.apache.xalan.xslt.ElemVariable.getValue(ElemVariable.java:180)

	at org.apache.xalan.xslt.ElemVariable.execute(ElemVariable.java:146)

	at
org.apache.xalan.xslt.Stylesheet.pushTopLevelVariables(Stylesheet.java:973)

	at
org.apache.xalan.xslt.XSLTEngineImpl.resolveTopLevelParams(XSLTEngineImpl.ja
va:3130)

	at
org.apache.xalan.xslt.StylesheetRoot.process(StylesheetRoot.java:433)

	at
org.apache.xalan.xslt.XSLTEngineImpl.process(XSLTEngineImpl.java:679)

	at
org.apache.cocoon.transformer.XalanTransformer.transform(XalanTransformer.ja
va:107)

	at
org.apache.cocoon.processor.xsp.XSPLogicsheet.apply(XSPLogicsheet.java:102)

	at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:445)

	at org.apache.cocoon.Engine.handle(Engine.java:384)

	at org.apache.cocoon.Cocoon.service(Cocoon.java:183)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:208)

	at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:1127)

	at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:1529)

	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)

	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

---------

org.apache.xalan.xpath.XPathException: pattern = '$environment = 'cocoon1''

VariableReference given for variable out of context or without definition!
Name = environment

	at org.apache.xalan.xpath.XPath.error(XPath.java:1562)

	at org.apache.xalan.xpath.XPath.variable(XPath.java:898)

	at org.apache.xalan.xpath.XPath.execute(XPath.java:1375)

	at org.apache.xalan.xpath.XPath.equals(XPath.java:586)

	at org.apache.xalan.xpath.XPath.execute(XPath.java:1358)

	at org.apache.xalan.xpath.XPath.execute(XPath.java:1354)

	at org.apache.xalan.xpath.XPath.execute(XPath.java:311)

	at org.apache.xalan.xslt.ElemChoose.execute(ElemChoose.java:118)

	at
org.apache.xalan.xslt.ElemTemplateElement.executeChildren(ElemTemplateElemen
t.java:661)

	at
org.apache.xalan.xslt.XSLTEngineImpl.createResultTreeFrag(XSLTEngineImpl.jav
a:2179)

	at
org.apache.xalan.xslt.ElemVariable.getValue(ElemVariable.java:180)

	at org.apache.xalan.xslt.ElemVariable.execute(ElemVariable.java:146)

	at
org.apache.xalan.xslt.Stylesheet.pushTopLevelVariables(Stylesheet.java:973)

	at
org.apache.xalan.xslt.XSLTEngineImpl.resolveTopLevelParams(XSLTEngineImpl.ja
va:3130)

	at
org.apache.xalan.xslt.StylesheetRoot.process(StylesheetRoot.java:433)

	at
org.apache.xalan.xslt.XSLTEngineImpl.process(XSLTEngineImpl.java:679)

	at
org.apache.cocoon.transformer.XalanTransformer.transform(XalanTransformer.ja
va:107)

	at
org.apache.cocoon.processor.xsp.XSPLogicsheet.apply(XSPLogicsheet.java:102)

	at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:445)

	at org.apache.cocoon.Engine.handle(Engine.java:384)

	at org.apache.cocoon.Cocoon.service(Cocoon.java:183)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

	at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:208)

	at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:1127)

	at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:1529)

	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)

	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

Warning: this page has been dynamically generated. 	

Copyright (c) 1999-2001 The Apache XML Project <http://xml.apache.org/> .
All rights reserved. 

AYUB KHAN

1500, 1075 West Georgia Street
Vancouver, B.C.   V6E 3C9

(604) 642-2329   Off.
AKhan@burntsand.com <mailto:AKhan@burntsand.com>  

 <http://www.burntsand.com/>  

Mime
View raw message