<category name="transformer.sql" log-level="DEBUG">
<log-target
id-ref="sitemap"/>
<log-target
id-ref="error"/>
</category>
in the end it should look something like:
<category name="sitemap" log-level="INFO">
<log-target id-ref="sitemap"/>
<log-target id-ref="error"/>
<category name="transformer.sql"
log-level="DEBUG">
<log-target id-ref="sitemap"/>
<log-target
id-ref="error"/>
</category>
<category name="handled-errors" log-level="INFO">
<!-- Exceptions that will be handled by a sitemap errorhandler are
logged to this target. -->
<log-target id-ref="handled-errors"/>
</category>
-----Original Message-----
From: Hiral Parikh [mailto:[EMAIL PROTECTED]
Posted At: Monday, August 30, 2004 8:01 PM
Posted To: Cocoon User List
Conversation: SQLTransformer and MySQL problem
Subject: RE: SQLTransformer and MySQL problemAll,Please let me know if anyone has any ideas about my problem that I posted last week....I still can't get SQLTransformer working with MySQL.. I am running cocoon 2.1.4 on MAC OS X. I need a third eye to look at my issue and cocoon user group is the only place i can rely on..also, where can i find root.log or cocoon.log.. after turning on the debug mode, i could see that SQLTransformer is called by looking at the sitemap.log but i have no idea whether it creates any database connection or anything... where can i find this info?help, help!regards,Hiral
From: Hiral Parikh [mailto:[EMAIL PROTECTED]
Sent: Friday, August 27, 2004 10:03 AM
To: [EMAIL PROTECTED]
Subject: SQLTransformer and MySQL problemHi 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 elementAny 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
