what result do you get if you save the result of the query as an xml file and transform the result in a second step with syxon and your xslt? Which step generates the error?
Markus
On 9/14/05, Mike Holt <[EMAIL PROTECTED]> wrote:
Hi Derek, thanks for the suggestion but no, the problem is not with the XSP page. I've created a very simple XML page containing a basic query and still get the same outcome. The error appears to indicate this is something to do with the result type not being defined or cast. Perhaps this is something to do with me using XSLT 2.0?
At 10:44 14/09/2005, you wrote:
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="" />
<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="" />
> <map:transform type="xslt" src="" />
> <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]
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.24/101 - Release Date: 13/09/2005