SQLTransformer problem

[Mike Holt <mi...@zenserve.com>]

Hi,

I'm perplexed by an error that I keep receiving when trying to 
process an XSL page contain a dynamic SQL query:

Description: org.apache.cocoon.ProcessingException: Exception in 
ServerPagesGenerator.generate(): java.lang.IllegalArgumentException: 
Unknown type of result: class javax.xml.transform.dom.DOMResult

My sub-sitemap contains the following:

<map:match pattern="*.xsp">
   <map:generate type="serverpages" src="pages/{1}.xsp" />
   <map:transform type="xslt" src="transforms/stylesheet.xsl" />
   <map:transform type="sql">
     <map:parameter name="use-connection" value="vouchers" />
     <map:parameter name="clob-encoding" value="UTF-8" />
   </map:transform>
   <map:serialize type="xhtml" />
</map:match>

...and the stylesheet contains the following:

<xsl:template match="updatesql">
   <execute-query xmlns="http://apache.org/cocoon/SQL/2.0">
     <query>select * from reference</query>
   </execute-query>
</xsl:template

The sql namespace is properly declared in both the XSP and the 
stylesheet, and I know that the connection pool is correctly defined 
and that the connection is working as I am using esql elsewhere in 
the source XSP without any problems. I'm using Saxon8 as my processor.

Any help with this would *greatly* appreciated.

Thanks,

Mike