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]>