You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by AK...@burntsand.com on 2001/02/08 00:05:08 UTC
Help with ESQL
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 <ma...@burntsand.com>
<http://www.burntsand.com/>
Re: Help with ESQL
Posted by Donald Ball <ba...@webslingerZ.com>.
On Wed, 7 Feb 2001 AKhan@burntsand.com wrote:
> <?xml-stylesheet type="text/xsl" href="esql.xsl"?>
this is your problem. the esql logicsheet isn't invoked by the xslt
processor. it should be handled automatically if you installed
the cocoon.properties from 1.8.2. this PI should link to _your_
stylesheet.
- donald