cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <dho...@csir.co.za>
Subject Re: SQLTransformer problem
Date Wed, 14 Sep 2005 13:07:41 GMT
Mike

Sorry, I am not familiar with XSLT2.0 - can this be handled by Saxon8?
Do you have the same problem if you remove the 2.0 specific functions
from the stylesheets?

Derek

>>> mike@zenserve.com 2005/09/14 02:52:35 PM >>>
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="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

>>> mike@zenserve.com 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, Joshua.Schairbaum@chase.com 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: users-unsubscribe@cocoon.apache.org 
>For additional commands, e-mail: users-help@cocoon.apache.org 
>
>
>
>--
>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: users-unsubscribe@cocoon.apache.org 
For additional commands, e-mail: users-help@cocoon.apache.org 




-- 
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
HelpDesk@csir.co.za.


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: users-unsubscribe@cocoon.apache.org 
For additional commands, e-mail: users-help@cocoon.apache.org 



-- 
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

-- 
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
HelpDesk@csir.co.za.


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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message