Hi all,
I am a newbie to Cocoon (2.1.4) and am trying to set it up to work with MySQL 3. 0.14 using SQLTransformer. I have followed all the instructions on the Cocoon website to do the necessary setup in Cocoon.xconf, web.xml and in the sitemap.xmap files.
I keep on getting this error:
_____________________
Failed to execute pipeline.
org.apache.cocoon.ProcessingException: Failed to execute pipeline.: java.lang.RuntimeException: java.lang.IllegalStateException: SQLTransformer: Not expecting an end execute query element
Any help is greatly appreciated and also if someone can suggest some good debugging techniques for Cocoon. Following are the files in use:
________
Article.xml:
<?xml version="1.0"?>
<article/>
_____________
Articlesql.xsl:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:sql="http://apache.org/cocoon/SQL/2.0">
<xsl:template match="article">
<article>
<sql:execute-query>
<sql:query>SELECT * FROM ARTICLE_TEST</sql:query>
</sql:execute-query>
</article>
</xsl:template>
</xsl:stylesheet>
_______________
Sitemap.xmap:
<map:match pattern="article">
<map:generate src="" type="file"/>
<map:transform src="" type="xslt">
<map:parameter name="use-request-parameters" value="true"/>
</map:transform>
<map:transform type="sql">
<map:parameter name="use-connection" value="mysqltest"/>
<map:parameter name="show-nr-of-rows" value="true"/>
<map:parameter name="clob-encoding" value="UTF-8" />
</map:transform>
<map:transform type="log"/>
<map:serialize type="xml"/>
</map:match>
THESE ARE MY TRANSFORMERS SPECIFIED IN THE ABOVE SITEMAP.XMAP:
<map:transformers default="xslt">
<map:transformer logger="sitemap.transformer.sql" name="sql" src="">
</map:transformer>
<map:transformer name="log" src="">
</map:transformers>
_____________
Cocoon.xconf
THIS IS MYSQL CONNECTION INFO
<datasources>
<!-- MySql database connection-->
<jdbc name="mysqltest">
<pool-controller min="5" max="10"/>
<dburl>jdbc:mysql://localhost:3306/test</dburl>
</jdbc>
</datasources>
_________________
Web.xml
THIS IS THE ENTRY FOR MYSQL DRIVER
<init-param>
<param-name>load-class</param-name>
<param-value>
<!-- For parent ComponentManager sample:
org.apache.cocoon.samples.parentcm.Configurator -->
<!-- For IBM WebSphere:
com.ibm.servlet.classloader.Handler -->
<!-- For Database Driver: -->
org.hsqldb.jdbcDriver
<!-- For MySQL Driver: -->
com.mysql.jdbc.Driver
</param-value>
</init-param>
__________________
Sitemap.log
INFO (2004-08-26) 17:14.05:445 [sitemap.transformer.log] (/orahelper/article) PoolThread-3/LogTransformer: [startDocument]
INFO (2004-08-26) 17:14.05:447 [sitemap.transformer.log] (/orahelper/article) PoolThread-3/LogTransformer: [startPrefixMapping] prefix=sql,uri=http://apache.org/cocoon/SQL/2.0
INFO (2004-08-26) 17:14.05:447 [sitemap.transformer.log] (/orahelper/article) PoolThread-3/LogTransformer: [startElement] uri=,local=article,raw=article
INFO (2004-08-26) 17:14.05:449 [sitemap.transformer.log] (/orahelper/article) PoolThread-3/LogTransformer: [startElement] uri=http://apache.org/cocoon/SQL/2.0,local=execute-query,raw=sql:execute-query
INFO (2004-08-26) 17:14.05:449 [sitemap.transformer.log] (/orahelper/article) PoolThread-3/LogTransformer: [startElement] uri=http://apache.org/cocoon/SQL/2.0,local=query,raw=sql:query
INFO (2004-08-26) 17:14.05:450 [sitemap.transformer.log] (/orahelper/article) PoolThread-3/LogTransformer: [characters] SELECT * FROM ARTICLE_TEST
INFO (2004-08-26) 17:14.05:451 [sitemap.transformer.log] (/orahelper/article) PoolThread-3/LogTransformer: [endElement] uri=http://apache.org/cocoon/SQL/2.0,local=query,raw=sql:query
INFO (2004-08-26) 17:14.05:451 [sitemap.transformer.log] (/orahelper/article) PoolThread-3/LogTransformer: [endElement] uri=http://apache.org/cocoon/SQL/2.0,local=execute-query,raw=sql:execute-query
INFO (2004-08-26) 17:14.05:452 [sitemap.transformer.log] (/orahelper/article) PoolThread-3/LogTransformer: [endElement] uri=,local=article,raw=article
INFO (2004-08-26) 17:14.05:477 [sitemap] (/orahelper/article) PoolThread-3/HandleErrorsNode: Processing handle-errors at file:/Users/a4a/cocoon-2.1.4/build/webapp/sitemap.xmap:767:24
INFO (2004-08-26) 17:14.06:636 [sitemap.transformer.log] (/orahelper/article) PoolThread-1/LogTransformer: [setup]
ANY HELP IS GREATLY APPRECIATED!!
Thanks,
Hiral
