Mike
My XSP is a bit rusty now (having mostly moved to JXTemplates)
but isn't the problem with the XSP and not the XSLT ie.
" Exception in ServerPagesGenerator.generate()"
Do you get the same error when you run:
<map:match pattern="*.xsp">
<map:generate type="serverpages" src="pages/{1}.xsp" />
<map:serialize type="xml" />
</map:match>
If so, try commenting out sections of your XSP until you
narrow down the source of the problem.
Sorry not to have more specific advice.
Derek
>>> [EMAIL PROTECTED] 2005/09/14 11:22:20 AM >>>
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]
--
This message is subject to the CSIR's copyright, terms and conditions and
e-mail legal notice. Views expressed herein do not necessarily represent the
views of the CSIR.
CSIR E-mail Legal Notice
http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html
CSIR Copyright, Terms and Conditions
http://mail.csir.co.za/CSIR_Copyright.html
For electronic copies of the CSIR Copyright, Terms and Conditions and the CSIR
Legal Notice send a blank message with REQUEST LEGAL in the subject line to
[EMAIL PROTECTED]
This message has been scanned for viruses and dangerous content by MailScanner,
and is believed to be clean. MailScanner thanks Transtec Computers for their
support.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
