Mike,
Try placing "sql:" in front of the <execute query/> and <query/> tags.
|---------+---------------------------->
| | Mike Holt |
| | <[EMAIL PROTECTED]|
| | m> |
| | |
| | 09/13/2005 01:35 |
| | PM |
| | Please respond to|
| | users |
| | |
|---------+---------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: [email protected]
|
| cc:
|
| Subject: SQLTransformer problem
|
>------------------------------------------------------------------------------------------------------------------------------|
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]
