I have problems to get an output of my db-data.
The database-pool(connection to my db) works fine, I had tested it with the
esql.xsp file which came with the cocoon application ( I changed the
original pool with my db-pool and it read the data correctly from my
database (mysql)).
In the basic.xml file I tested also a <xsp:logic> expression which works fine.
I got also problems to use a logicsheet ... may be this could be a hint ?
Sorry for this long posting, but I am new to xml/cocoon and thought I could
be helpful to see the whole structure of this test-application.
Thank you in advance !!!
my directory structure:
directory structure:
/cocoon
/test
basic.xsl
sitemap.xmap
/xsp
basic.xml
my basic.xsl file:
<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; version="1.0">
<xsl:template match="page">
<html>
<head>
<title><xsl:value-of select="title"/></title>
</head>
<body>
<h1><xsl:value-of select="title"/></h1>
<p><xsl:value-of select="greeting"/></p>
<p><xsl:value-of select="db"/></p>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
my basic.xml file:
<?xml version="1.0"?>
<xsp:page laguage="java" xmlns:xsp="http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";>
<page>
<title>Select from Database</title>
<greeting>Here is the result:</greeting>
<esql:connection>
<esql:pool>xmldb</esql:pool>
<esql:execute-query>
<esql:query>select * from document where
DocID=1</esql:query>
<esql:results>
<esql:row-results>
<db>
<esql:get-columns/>
</db>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</page>
</xsp:page>
my sitemap.xmap:
<!-- minimal sitemap for Cocoon 2 test -->
<map:sitemap xmlns:map="http://apache.org/cocoon/sitemap/1.0";>
<!-- =========================== Components
================================ -->
<map:components>
<map:generators default="file"/>
<map:transformers default="xslt"/>
<map:readers default="resource"/>
<map:serializers default="html"/>
<map:selectors default="browser"/>
<map:matchers default="wildcard">
<map:matcher name="wildcard"
src="org.apache.cocoon.matching.WildcardURIMatcherFactory"/>
</map:matchers>
</map:components>
<!-- =========================== Pipelines
================================= -->
<map:pipelines>
<map:pipeline>
<map:match pattern="xsp/*">
<map:generate type="serverpages"
src="xsp/{1}"/>
<map:transform type="xslt" src="basic.xsl"/>
<map:serialize/>
</map:match>
</map:pipeline>
</map:pipelines>
</map:sitemap>
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
