Hi Joshua, thanks for the response. It makes no difference if I add
the sql prefix or not.
Mike
At 20:30 13/09/2005, [EMAIL PROTECTED] wrote:
Mike,
Try placing "sql:" in front of the <execute query/> and <query/> tags.
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.23/99 - Release Date: 12/09/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
