Hi, I'm using SQL server (although I'm not sure how the db used would make a difference). However, I have found a workround for my problem, which is to recreate the xml rather than copy it. This isn't too bad for me as the XML I'm using has no attributes e.g.
<xsl:template match="*"> <xsl:variable name="nodeName"><xsl:value-of select="name()"/></xsl:variable> <xsl:element name="{$nodeName}"><xsl:apply-templates/></xsl:element> </xsl:template> This generates the same output as the copy but for some reason works! So, I still don't understand what causes the original problem but this is good enough for the moment, Cheers Grant -----Original Message----- From: Luca Morandini [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 27, 2002 12:56 PM To: [EMAIL PROTECTED] Subject: RE: [C2] Bug in SQL transformer? Harald, bottom line is: the problem lies in the stylesheet. I don't think is a good idea splitting the template "@*|node()", since the first half extracts only attributes, while the second half only nodes. Hence, splitting this template will result in extracting attributes first and nodes afterwards. Anyhow, why don't you just try to see what the results of the query (or stored procedure) are ? You can do this by omitting the transformation part of the pipeline and having Cocoon ouput xml instead of html. You can then build a stylesheet from scratch, avoiding to use the one provided in the examples. Best regards, --------------------------------------------- Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html --------------------------------------------- > -----Original Message----- > From: SunnyDay [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 26, 2002 6:10 PM > To: [EMAIL PROTECTED] > Subject: Re: [C2] Bug in SQL transformer? > > > Hi Luca, > > the clean machine does the same - but only if I access my ORACLE-DB!! > > Now I commented out the line in the stylesheet which Grant (the > originator of this thread - you remember ;) mentioned - and it worked - > no exception no error page ... > > I decided to split the line from > > <xsl:template match="@*|node()" priority="-2"> > <xsl:copy> > <xsl:apply-templates select="@*|node()"/> > </xsl:copy> > </xsl:template> > > into > > <xsl:template match="@*" priority="-2"> > <xsl:copy> > <xsl:apply-templates select="@*"/> > </xsl:copy> > </xsl:template> > > <xsl:template match="node()" priority="-2"> > <xsl:copy> > <xsl:apply-templates select="node()"/> > </xsl:copy> > </xsl:template> > > The crash onyl occurs if the node() template is used! > And only if I use Oracle! > > Grant, what DB do you use? Oracle? Version? > Luca, do have the possibility to verify the things above? > > kind regards > Harald > > > SunnyDay wrote: > > > Hi Luca, > > > >> keep in mind that, when you modify an imported stylesheets, you have to > >> modify the importing stylesheet as well... otherwise Cocoon won't > >> notice the > >> imported stylesheet has changed and will re-use the old > (cached) version. > > > > > > I even deleted the work-dir and restarted tomcat ... > > > > I decided to setup a new linux box tonight - so I'll see what happens > > with a complete clean maschine ... > > > > best regards > > harald > > > > > > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>