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

Reply via email to