cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Holt <m...@zenserve.com>
Subject Re: SQLTransformer problem
Date Wed, 14 Sep 2005 14:43:35 GMT
Hi Markus, the processing fails during the retrieval step from the 
database - there are no apparent errors in my source or stylesheet. 
If I place the SQL transformer after the Trax transformer in the 
pipeline, I get the literal text of the query.


At 14:49 14/09/2005, Markus Vaterlaus wrote:
>Hello Mike,
>
>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 <<mailto:mike@zenserve.com>mike@zenserve.com> 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="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
>>
>> >>> <mailto:mike@zenserve.com>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, 
>><mailto:Joshua.Schairbaum@chase.com>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> 
>> 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: 
>> <mailto:users-unsubscribe@cocoon.apache.org>users-unsubscribe@cocoon.apache.org

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

>>
>>For additional commands, e-mail: 
>><mailto:users-help@cocoon.apache.org>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>http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html

>>
>>
>>CSIR Copyright, Terms and Conditions
>><http://mail.csir.co.za/CSIR_Copyright.html>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
>><mailto:HelpDesk@csir.co.za>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: 
>><mailto:users-unsubscribe@cocoon.apache.org>users-unsubscribe@cocoon.apache.org
>>For additional commands, e-mail: 
>><mailto:users-help@cocoon.apache.org>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
>
>
>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

Mime
View raw message